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

<< Iran Blocks, Unblocks Access to Google | Home | Simple Command Line MD5 Check >>

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

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

Dude this was a great help for me.
thanks for the tip

Left by Saman on Sep 04, 2008 6:46 PM

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

Nicely written, easy to understand, and works like a charm, thank you.

Left by Ron Smith on Sep 19, 2008 4:25 PM

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

How do you determine the name of the Full Text Catalog?

Left by Jimbo on Oct 26, 2008 4:01 AM

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

Clear and helpful instructions.

Left by Jon Arancio on Jan 30, 2009 4:26 AM

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

catalog_name:
Is the name of the catalog to be removed. If catalog_name does not exist, Microsoft SQL Server returns an error and does not perform the DROP operation. The filegroup of the full-text catalog must not be marked OFFLINE or READONLY for the command to succeed.

Left by sicherste Casinos on Feb 17, 2010 9:21 AM

Your comment:

Title:

Name:

Email: (never displayed)

(will show your gravatar)

Website:

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Please add 1 and 2 and type the answer here:

Enter the code shown above:

Tech Guru