Fulltext catalogs are used when you are searching text fields in advanced ways such as:
-
Two words near each other
-
Any word derived from a particular root (for example run, ran, or running)
-
Multiple words with distinct weightings
-
A word or phrase close to the search word or phrase
-
Better performance alternative vs. frequent LIKE %text% query matches
To have a Full Text catalog created, please open a support ticket to us, with your table name, along with the text fields that you want indexed. Note that the table must contain a key - a column that is both narrow and numeric, such as one created by an using an Identity column - and should have a timestamp column as well. We will create the full text catalog, fully populate it, and set it to populate incrementally once a day.
For more information on using full text catalogs, refer to the following articles:
Building Search Applications for the Web Using Microsoft SQL Server 2000 Full-Text Search
http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_fulltextsearch.asp
SQL Server Full-Text Search Performance Tuning and Optimization
http://www.sql-server-performance.com/full_text_search.asp
SQL Server Full Text Search Optimization
http://www.sql-server-performance.com/tb_search_optimization.asp