Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Full text admin tool

Author  Topic 

geossl
Yak Posting Veteran

85 Posts

Posted - 2005-05-30 : 09:21:43
Dear All,
A full text index is setup on a testing machine with Query Analyzer and Enterprise Manager. It works alright. It can be administered on another client PC with Enterpise Manager.

However, when a full text index is setup on the production machine. It cannot be administered on a remote PC using Enterprise Manager(It is not enabled using right click on the table) . Morever, the query result with full text index seems not correct.

Any problem?

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-05-31 : 14:35:34
I am surprised you can get an example of remote management using Enterprise Manager on a Full Text index to work at all. My understanding was that it would not. However, you can issue all of the necessary commands to create, populate, update, etc. the full text index from Query Analyzer remotely. Or, you can use something like remote desktop to access the server and run the server's Enterprise Manager, assuming it is installed. I encourage option 1.

---------------------------
EmeraldCityDomains.com
Go to Top of Page
   

- Advertisement -