How to enable Full Text Search in Enterprise Manager ?

[Ranvier]

Hi,

I am trying to set up Full Text Search from Enterprise Manager and am having trouble turning it on. If I select 'Tools' drop down menu my 'Full Text Indexing' is greyed out and I cant select it. Can someone tell me how I can enable this so I can set up Full Text Search.

Thank you

 

[ptheriault]

You have to enable full text for the database.

sp_fulltext_database 'enable'

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[Ranvier]

Hi Paul,,

Thanks for that. I think I still need to do something else as I get the following error message when I run the procedure

Error Message....

////////////
(1 row(s) affected)

Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database, Line 46
Full-Text Search is not installed, or a full-text component cannot be loaded.
////////////////////

Any ideas what i'm missing or how I can find out>

Thanks

 

[mutley1]

What version of SQL aer you running?

Run this in QA and post the results.

Select @@version

 

[Ranvier]

//////////////

Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

//////////////

 

[mutley1]

Hi Ranvier,

I'd start off by applying the latest service packs as that is bog standard version of developer. Try that and let us know if it has any effect.

Cheers,

M.

 

[Ranvier]

Thanks, I will try that and see how I go, thanks for your help

R