Full-text search is not enabled for the current database. How can I enable it for Helpdesk?
If you are using MSDE as a backend, you can't enable full-text indexing. It is one of the restrictions of MSDE.
Activating full-text indexing on a SQL server is reasonably straightforward and you can use the wizard in Enterprise Manager, or you can use the stored procedures—such as sp_fulltext_database. You need to enable full-text indexing for the title and comment fields in the workitem table.
To check if full-text indexing is installed on your server, open Query Analyzer and enter:
Press the little green arrow icon to run the command. If it responds with 1, then the service has been installed. You can start it on the Altiris_Incidents database by running: