Problem initializing full-text search

[brouse]

I am trying to run "sp_fulltext_database 'enable'" to enable full-text search on a DB. I get the error message:

"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."

Particulars:

MS-SQL Server 2K (actually MSDE)
OS: MS XP, sp1
Indexing Service and MS-SQL Service both running as local system account
Logged in as a local admin

Any thoughts?

Thanks...

[Phil Weber]

I don't think MSDE supports full-text search. For development, you may use SQL Server Developer Edition; for deployment, I believe you'll need the Enterprise or Workgroup Editions.

[brouse]

Bummer... I suspected as much. Do you have a link to a page where MS says that explicitly (I couldn't find one)? We sell a lower end product (hence MSDE), and I want to be certain when we tell customers that if they want full-text retrieval, they need to upgrade to full-blown MS-SQL.

Thanks,

[Phil Weber]

How about this?
http://msdn.microsoft.com/library/ps...ar_ts_1cdv.htm