Re: Full-Text options disabled in management console

I wish I could offer you a magic bullet to solve this problem. I just use
the wizard or the procs and be done with it.

--
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



"Brad" <lane@xxxxxxxxxxxxxxxx> wrote in message
news:OIv3JK9NGHA.2268@xxxxxxxxxxxxxxxxxxxxxxx
Well, I'm already a memeber of the local admin group and sql sysadmins
...but I tried using the SA login and had same issue.

Brad

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OrTBjJwNGHA.2828@xxxxxxxxxxxxxxxxxxxxxxx
I've run into this myself. Close down Enterprise Manager and reopen it and
this time connect using SA or a member of the Local Administrator group
which is also in the sysadmin role. I normally just use the command line
full-text indexing wizard or use the procs.
--
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



"Brad" <lane@xxxxxxxxxxxxxxxx> wrote in message
news:eBOm219MGHA.984@xxxxxxxxxxxxxxxxxxxxxxx
If I open a SQL 2000 database using the management console the Full-Text
options are grayed-out / disabled...even though Full-Text search service
is
started and I can create full-text catalogs using stored procedures in QA
and search using those catalog in QA. This problem occurs on my local
copy
of SQL 2000 (developer edition) and on server editions installed on
servers.
I am a sysadmin in all cases and I am an admin on the computers .

More information:
If I open enterprise manager console and navigate to a MS SQL 2000
database,
right click on the database "New Full-Text Catalog is grayed
out/disabled.
If I navigate to a table in the database and right click on the table
"Full-Text Index Table" is grayed out/disabled....even though I can
create
a
catalog on the same table using QA and search on that table using the
catalog.
If I right click on a full text catalog object the following menu options
are disabled/grayed out: New Full-Text Catalog, Rebuild Catalog, Stop
Population (at least this one makes sense) and Schedules.

I can run the full-text indexing wizard and create the index from the
command line.

My local pc is Win2003 server sp1 with SQL Server 2000 sp4
Server is Win2000 with SQL Server 2000 sp4

Any suggestions, hints or references to articles, kb or other would be
appreciated.

Brad









.

Relevant Pages

  • Re: Cannot Open SQL Server Table in Access.ADP File.
    ... (SQL Server Import and Export Wizard) ... I understand that you'd like to script out database diagram. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... want to run sp_updatestats after the restore or attach as well. ... >>There is a lot more that can go wrong with the wizard ... > SQL Server Databases ... >>Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.setup)
  • Re: Loss of Search in WSS
    ... Search uses the full text catalog that you can see in Enterprise Manager ... for SQL Server to get around to it. ... Not in a table in the database. ... During the move you may have stopped the repopulation. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Full-Text options disabled in management console
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... and search using those catalog in QA. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Data Source error... help!?
    ... installed the SQL Server 2000 connectivity files from the SQL Server ... I just can't connect at all from the New Data Source wizard. ... SQL Server 2000 Standard database on another machine. ... Here is the connection string it's ...
    (microsoft.public.dotnet.languages.vb)