Search for a string over all columns in a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 30 May 2005 14:47 GMT

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 !

Reply to this Message

Hilary Cotter - 30 May 2005 15:18 GMT

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.

Signature

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

>I would like to perform a search for a string (for example "0021-899-1234")
>that could reside in any table
[quoted text clipped - 8 lines]
>
> Thanks !

Reply to this Message