fts within a single record

I am hoping that someone has an "it's obvious" solution. I have a bunch (~100) of text fields in a single record. I want a user to be able to search all of the fields (within this single record) for a string, and to return the field number(s) of where the string was found. Is there a way to do this within the MSSQL server's built in fts catalog, (or some other product) or do I need to code this by hand? I could limit the searchable strings to a finite set, if needed.I believe that you can do this with Full Text Search. You must, however, have a finite set of columns to search upon. You must also have a primary key for the Full Text Search engine to be able to identify the specific record with matching search criteria.

You must enable install and enable Full Text Search (it is not installed by default). You must then create the Full Text Search process (I cheat like crazy and use the wizard in EM; this is NOT recommended). It is recommended that you use QA and create the processes yourself.

You will need to populate the Full Text catalogue initially and then create a schedule to update the Full Text catalogue periodically.

Regards,

Hugh Scott

Originally posted by wooliewillie
I am hoping that someone has an "it's obvious" solution. I have a bunch (~100) of text fields in a single record. I want a user to be able to search all of the fields (within this single record) for a string, and to return the field number(s) of where the string was found. Is there a way to do this within the MSSQL server's built in fts catalog, (or some other product) or do I need to code this by hand? I could limit the searchable strings to a finite set, if needed.

fts catalog size

I am new to using FTS for searching, so please forgive the ignorance if there is an obvious answer. I've set up a table specifically to hold searchable data rather than have a number of table joins for searching. I've imported about 1/4 of the data into the table and set up a catalog on the table. The catalog is currently 62 mb. Is there a suggested limit to a catalog size for FTS and if so, is there a way to set up a catalog so that when it reaches this size, it splits off and creates a 2nd catalog? Thanks.No you can't throttle the size, nor can you have another catalog created dynamically. Note that a full text index for a table can't span catalogs, ie one index one catalog. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 wrote in message news:ec61e74c-e1b9-4f40-a99c-0c7ada543225@.discussions.microsoft.com... I am new to using FTS for searching, so please forgive the ignorance if there is an obvious answer. I've set up a table specifically to hold searchable data rather than have a number of table joins for searching. I've imported about 1/4 of the data into the table and set up a catalog on the table. The catalog is currently 62 mb. Is there a suggested limit to a catalog size for FTS and if so, is there a way to set up a catalog so that when it reaches this size, it splits off and creates a 2nd catalog? Thanks.