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?
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.