sql server full text search: Fulltext Catalogs in SQL 2005 Express -- sql server full text search

Fulltext Catalogs in SQL 2005 Express

GitarJake
4/18/2007 9:07:45 PM

sql server full text search:

Hello,

SQL Server Express 2005 with the Management Studio.

In SQL 2000, you can right click fulltext catalogs and select a "Rebuild"
option.

I can't find where to do this in the Management Studio. I don't even see a
"Storage" section.

How do you manage Fulltext Catalogs in 2005 Express?

TIA,
Jake

Re: Fulltext Catalogs in SQL 2005 Express

spencer
4/18/2007 9:26:46 PM

This is the simplest form for a catalog rebuild query:

ALTER FULLTEXT CATALOG <CATALOG_NAME> REBUILD

There are other options you can use as well. See documentation.

There are also system stored procedures. See sp_fulltext_catalog, with
emphasis on the action parameter.

[quoted text, click to view]

Re: Fulltext Catalogs in SQL 2005 Express

Hilary Cotter
4/19/2007 12:00:00 AM

Are you sure you have full-text installed on this express instance? You need
to install it through the Advanced Services download

http://www.microsoft.com/downloads/details.aspx?familyid=4c6ba9fd-319a-4887-bc75-3b02b5e48a40&displaylang=en

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server full text search group.