views:

31

answers:

1

I would like to get "content" () of full text search index as described in http://en.wikipedia.org/wiki/Inverted_index and http://en.wikipedia.org/wiki/Microsoft_SQL_Server#Full_Text_Search_Service. Content - name of word and occurences

This question is related with my previous question without answer http://stackoverflow.com/questions/3475104/dynamic-tags-generation-from-sql-server-database-using-full-text-search

Is it possible?

A: 

In SQL Server 2008 you can query the sys.dm_fts_index_keywords and sys.dm_fts_index_keywords_by_document table valued functions to get this information.

For previous versions I think this is much less easily accessible (if at all)

Martin Smith
Yes it works if sql server is 2008 but on production env. we've got 2005 ... I am still looking for solution.
marcinn