How to enable Full text search

[Larshg]

I am running a MS-SQL2000 database, but I can't seem to find the Fulle Text Catalogs in my database, it is not under support servises either.

I don't think that it is enabeled, but I have no clue hpw to do this. - hope someone can help me

 

[fluteplr]

I am pretty sure it has to be enabled at install time, and it is not installed by default. You should be able to do an update install and add it. As with any install if this is not a test server (an even if it is ) do a full backup FIRST!!

 

[Larshg]

Well there is running two sql server on my machine and when I enter the "SQL Server Enterprise Manager" there are two servers under the "SQL server Group"

However only one af them have the "Full Text Catalogs"

The SQL server war installed only once and nobody knows why there are two, and I cant get an ODBC connection to the one that have the "Full Text Catalogs".

 

[mohmehran]

Are you running SQL Server 2000? If so, write me to tell you about the reason.
Mohammad Mehran Nikoo, MCP
mohmehran@yahoo.com