sql server full text search: Full-text search content -- sql server full text search

Full-text search content

alain NO[at]SPAM infoproasf.com
9/9/2007 9:48:02 PM

sql server full text search: 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

Re: Full-text search content

Hilary Cotter
9/10/2007 11:02:03 AM

Please refer to the post entitled search and index question from a few days
ago.

--
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
[quoted text, click to view]