SQL Server error '80040e14' - enable full-text search for the database

[biry]

How to over come this error?

Microsoft OLE DB Provider for SQL Server error '80040e14'

Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database.

 

[SQLSister]

WEll it depends. Clearly you have a query written to use full-text search. If it is not enables on a server, then it must be befoer the query will work. Either run
sp_fulltext_database 'enable'

or change the query to not use full text search.

Depending on the situation you may also need to populate the correct full-text search indexes if you have not done so.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[biry]

excuse my ignorance, but how does one do that, sql2k fully patched

thanks

 

[SQLSister]

Open Query analyzer and run:

exec sp_fulltext_database 'enable'

If that doesn't fix the problem, you will then need to identify the query using full text search and see what fields it expects to be in the full-text index and then create the index and populate it. Hopefully this is just happening becasue someone accidentally disabled the fulltext search and the indexes are already there. If you need to do this step, then read about fulltext search in BOL. It is kind of comlex to explain in a forum like this.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief