Hello,

(Sorry for my English.)

I am learning MS SQL Server 2005. I would like to use full-text search.

I have installed:

SQL Server 2005 Express Edition Advanced Services (SQLEXPR_ADV.EXE)

SQL Server 2005 Express Edition Toolkit SP1 (SQLEXPR_TOOLKIT.EXE)

The problem is that although I executed:

exec sp_fulltext_database enable

I cannot use full-text search. When I tried to call

exec sp_fulltext_service 'load_os_resources', 1

exec sp_fulltext_service 'verify_signature', 0

I got a message:

Full-Text Search is not installed, or a full-text component cannot be
loaded.

I cannot create full-text indexes, catalogs.

Please help. What should I do to be able to use full-text search. I cannot
find solution in Internet.

/RAM/

Moreover, I don't see full-text search in SQL Server 2005 Services of SQL
Server Configuration Manager.
Please help
/RAM/

[quoted text, click to view]

We are having the same issue as well. We also performed an upgrade
from the non-advanced services edition and cannot get the sp_fulltext
SPs to execute. Could it be an issue related to the upgrade and/or
configuration?c'mon, you can't tell me that if Keira was in the room
you wouldn't want to make out with her