Full-Text Index Table choice grayed out

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dw - 07 Mar 2006 13:58 GMT

Hi. I'm connecting to a database on SQL Server 2000 SP3 on which I'm the
dbo. However, when I right-click any of the tables, it has the "Full-Text
Index Table" item grayed out. Is this only available to members of the SA
group on the server? Thanks.

Reply to this Message

Russell Fields - 07 Mar 2006 16:51 GMT

Is your database full-text enabled? - RLF

> Hi. I'm connecting to a database on SQL Server 2000 SP3 on which I'm the
> dbo. However, when I right-click any of the tables, it has the "Full-Text
> Index Table" item grayed out. Is this only available to members of the SA
> group on the server? Thanks.

Reply to this Message

KEY - 07 Mar 2006 17:44 GMT

Yes it is enabled. Ran the stored procedure:

select fulltextserviceproperty('isFulltextInstalled')

The result was "1" which means that it is properly installed. According to
this article,
http://support.microsoft.com/default.aspx?scid=kb;en-us;270671&Product=sql2k
, if using client tools it will be greyed out. Anyone know if this is still
the case?

> Is your database full-text enabled? - RLF
>
> > Hi. I'm connecting to a database on SQL Server 2000 SP3 on which I'm the
> > dbo. However, when I right-click any of the tables, it has the "Full-Text
> > Index Table" item grayed out. Is this only available to members of the SA
> > group on the server? Thanks.

Reply to this Message

Hilary Cotter - 08 Mar 2006 02:27 GMT

http://www.indexserverfaq.com/TableNotEnabled.htm

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Reply to this Message