Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / February 2006

Tip: Looking for answers? Try searching our database.

Full-Text options disabled in management console

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brad - 17 Feb 2006 16:16 GMT
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
Hilary Cotter - 21 Feb 2006 16:18 GMT
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.
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

> 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
[quoted text clipped - 29 lines]
>
> Brad
Brad - 22 Feb 2006 17:07 GMT
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

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

> 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
[quoted text clipped - 29 lines]
>
> Brad
Hilary Cotter - 23 Feb 2006 02:10 GMT
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.

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

> 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.
[quoted text clipped - 40 lines]
>>
>> Brad
Brad - 23 Feb 2006 22:49 GMT
Yeah, that's what I've done....but the silver bullet would've been nice.

Brad

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.

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

> 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.
[quoted text clipped - 40 lines]
>>
>> Brad
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.