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

growse · 16 Feb 2006 at 09:58

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?

growse · 16 Feb 2006 at 19:40

bumpety?

zetec452 · 16 Feb 2006 at 19:53

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

growse · 16 Feb 2006 at 20:21

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.