1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[MSSQL] Is it possible to get a list of words in a fulltext index?

Discussion in 'HTML, Graphics & Programming' started by growse, 16 Feb 2006.

  1. growse

    Soldato

    Joined: 18 Oct 2002

    Posts: 7,139

    Location: Ironing

    I'm trying to do some clever AJAX search stuff, and my search is done through a fulltext index on a database in MSSQL 2000. If the fulltext index contains each word that is listed in the columns, is it possible to get a list of these words through SQL?
     
  2. growse

    Soldato

    Joined: 18 Oct 2002

    Posts: 7,139

    Location: Ironing

    bumpety?
     
  3. zetec452

    Sgarrista

    Joined: 15 Sep 2003

    Posts: 9,454

    Is it MSDE? If so you can't do full text searches.
     
  4. growse

    Soldato

    Joined: 18 Oct 2002

    Posts: 7,139

    Location: Ironing

    Enterprise edition. Fulltext is already enabled, and I can do fulltext queries, but I'd really like a list of words in the catalog, and how often they appear in a table column.