Fulltext Catalogs in SQL 2005 Express

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GitarJake - 19 Apr 2007 02:07 GMT

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

Reply to this Message

spencer - 19 Apr 2007 04:26 GMT

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.

> Hello,
>
[quoted text clipped - 10 lines]
> TIA,
> Jake

Reply to this Message

Hilary Cotter - 19 Apr 2007 12:42 GMT

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

> Hello,
>
[quoted text clipped - 10 lines]
> TIA,
> Jake

Reply to this Message