HOWTO: Drop an Offline Full-Text Catalog in Microsoft SQL Server 2005

First use the database you are looking for.
Then run as below:
SELECT name, ftcatid FROM sysobjects WHERE ftcatid > 0
For each returning table name (which are the tables with Full-Text Index), run below command:
EXEC sp_fulltext_table 'tblName', 'drop'
After all drop the Full-Text Catalog with:
DROP FULLTEXT CATALOG catalogName

Print | posted on Monday, September 24, 2007 6:07 AM

Comments on this post

No comments posted yet.

Your comment:

 (will show your gravatar)
 
Please add 6 and 1 and type the answer here: