Enabling - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Enabling

Author

Topic

sital
Yak Posting Veteran

89 Posts

Posted - 2009-04-16 : 02:40:37

Hi all

When I am executing the fillowing statement:

SP_FULLTEXT_DATABASE ENABLE

It is giving Command(s) completed successfully

However When I create fulltext catalog using the following statement:

CREATE FULLTEXT CATALOG CAT1 AS DEFAULT

It is giving the following error:
Msg 7609, Level 17, State 100, Line 1
Full-Text Search is not installed, or a full-text component cannot be loaded.

However When I try to enable the fulltext catalog using the following statement:

SP_FULLTEXT_CATALOG enable

It is giving me the following error:

Msg 201, Level 16, State 4, Procedure sp_fulltext_catalog, Line 0
Procedure or function 'sp_fulltext_catalog' expects parameter '@action', which was not supplied.

Can anyone identify the error? Please help me out with the correct query to use Ful Text Search.

Please help me how to incorporate a full text search?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-04-16 : 11:30:47

how can you enable full text catalog when you've not installed it? as said by first message, i think you need to install it first

AshaRRichardson
Starting Member

1 Post

Posted - 2009-10-06 : 13:24:52

I have this same problem. I am getting an error: Msg 7609, Level 17, State 100, Line 1
Full-Text Search is not installed, or a full-text component cannot be loaded.

But.... Full-text search is installed and running as a service this is sql server 2005

When I try to go enable it under the database->Properties->Files, the button is grayed out.
What do I do?

Asha Richardson

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources