Hi All Full-text search experts,
I have an SQL Server 200 Database running with full-text search
enabled and fully operationnal.
I am looking to get the Full-text catalog content to know what are the
most popular series of word in the full-text enabled fields.
Ex : If my full-text field has 4 rows
1st row : "This is a random information I need to check"
2nd row : "All of the words in the information are random"
3rd row : "There words need to check"
4th row : "This is information that I need to have a random check on
it"
I would like to reverse the search to get the results :
"information random" (appears 3 times)
"check" (appears 3 times)
"random" (Appears 3 times)
And so on...
Anyone know how to do this?
Thanks
Alain
Hilary Cotter - 10 Sep 2007 16:02 GMT
Please refer to the post entitled search and index question from a few days
ago.

Signature
RelevantNoise.com - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
> Hi All Full-text search experts,
>
[quoted text clipped - 20 lines]
>
> Alain