"New Full-text Catalog" Disabled

jdebelen · February 23rd, 2005, 03:06 AM

Hi, I'm using SQL Server Enterprise Manager. I want to create a full-text catalog, but it seems that it is disabled. I right clicked on "Full-Text Catalogs" and could not click on "New Full-Text Catalog". Aside from this, here are the other options that are currently disabled:

     1. Rebuild All Catalogs
     2. Repopulate All Catalogs
     3. Remove All Catalogs

Please help. How can I enable these features?
I am currently using:

     Microsoft Management Console 1.2
     Version 5.0 (Build 2195: Service Pack 4)

jemacc · February 23rd, 2005, 11:51 PM

To disable full text catalog

Code:

USE your database name
EXEC sp_fulltext_database 'disable'

To enable full text catalog

Code:

USE your databasename 
EXEC sp_fulltext_database 'disable'

Jaime E. Maccou

jdebelen · February 24th, 2005, 02:19 AM

But how do I enable/disable using Enterprise Manager?

jemacc · February 24th, 2005, 06:53 AM

sorry for the error

--------------------------------------------------------------------------------

To disable full text catalog

USE your database name ]-- This is the name of your Database
EXEC sp_fulltext_database 'disable'

To enable full text catalog

USE your database name -- This is the name of your Database
EXEC sp_fulltext_database 'enable'

execute the statement using Query Analyzer

Jaime E. Maccou