Implementing SQL Server 2008 Full-Text Catalogs
In SQL Server 2005 and previous versions, full-text catalogs were containers for your full-text indexes. In SQL Server 2008, they are really virtual containers on which you can tag various settings and have these settings apply to all indexes placed in that catalog (for example, accent sensitivity) or rebuild all indexes in a catalog at one time.
To create a full-text catalog, you first need to full-text enable your database. To do this, issue the following query in your database:
sp_fulltext_database 'enable'
You can also right-click on your database, select Properties, and then click on the Files tab. Check Use Full-Text Indexing and then click OK.
After doing this, you can create your catalog. ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
