sql server full text search: Search for a string over all columns in a database -- sql server full text search

Search for a string over all columns in a database

Rob
5/30/2005 9:47:55 AM

sql server full text search:

I would like to perform a search for a string (for example "0021-899-1234")
that could reside in any table

within a given database. (I performed a massive change and I would like to
spot check to ensure that I got all

occurrences of the proper columns.) Is there as easy way to set-up the
"Full Text Search" feature in order to

accomplish this ?

Thanks !

Re: Search for a string over all columns in a database

Hilary Cotter
5/30/2005 10:18:04 AM

No, you would have to union against all tables you have fulltext indexed.

Also you will have to make sure you have removed all numbers from your noise
word list and rebuilt the catalogs.

--
--
Hilary Cotter
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]