Sunday, February 26, 2012

Enabling full text search on existing sql server instance

Hi

I have an existing instance of sql express 2005 w/advanced services installed. When I installed I did not install full text search. Is there a way I can enable full text search on this existing instance?

Thanks

Try this:

sp_configure 'user instances enabled', '0'

sp_fulltext_database 'enable'

Then go ahead and try create your catalogs and indexes as normal.

No comments:

Post a Comment