Friday, February 24, 2012

Developer Edition issues and fulltext searching

I have SQLServer 2000 (Developer edition) and have installed SP3a in
an attempt to get full word in text searching. (both installed as
administrator on a Windows XP professional box)
However, I dont get MSSEARCH in the list of services and hence the
'Full Text' Indexing option is grayed out.
Also:
sp_fulltext_database 'enable' -- returns the following
(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.
HELP
re-run SQL Server setup and select the add additional components option. Select Full Text Search here.
|||Add/Remove Programs -> Windows Components -> Check "Indexing Service"
Bojidar Alexandrov

No comments:

Post a Comment