Error 15601: Full-Text Search is not enabled for the current database

[kg00se]

I am getting this error everytime that I try to rebuild the text search on a spacific sql2k db.

any ideas on how I can fix this easily would be greatly appreciated.


Thanks
kg00se

 

[Catadmin]

Are you sure Full Text is enabled on the database?

Go to your copy of Books Online and put "full-text, (See also full-text search" into the Index tab. It'll bring up the directions for setting up Full-Text searching on your database.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[kg00se]

yes it is enabled.
when I go to query analyzer and run sp_fulltext_database 'enable'

I get the following error:

Server: Msg 7608, Level 17, State 1, Procedure sp_fulltext_database, Line 46
An unknown full-text failure (80004005) occurred in function EnumCatalogs on full-text catalog ''.


kg00se

 

[Catadmin]

I'd start running some DBCC commands to see what's going on. DBCC CheckCatalog definately. Then look at the results of some of the others like CheckAlloc, etc. See if there's a page/extent corruption of some kind.

I hope it's not that, but running the DBCC commands is a fairly quick way to check that problem off your list.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[kg00se]

I know there is nothing wrong with the database it self I moved one of the databases that I was having problems with to a development box and enabled the fulltext search on it. and it runs fine. there is something with ms search that is the root of all my evil. just not sure what the best route is to fix it. so far I've tried everything that I have found on the net to fix it to no avail. and the sad thing is that there is no way that I can move all the databases off of that box to do a complete reload of the os.
I really hate when that happens.

kg00se

 

[mrdenny]

Try reapplying the most recent service packs to the OS and SQL. Maybe that will jump start the MS Search service.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com