How to Enable Full-Text Index on Sql Server 2008 Table

Answer 1

Not sure if you have looked through the documenation but Microsofts content is quite thorough and you should quickly be able to locate instruction for exactly what you are looking for withou too much poking around.

Here is an excellent place to start your research:

http://msdn.microsoft.com/en-us/library/ms142571.aspx

Answer 2

Thanks for the "kick in the pants" John. I had looked there, but as my wife says I "looked like a man". Second look turned up this page:

Administering Full-Text Search

And after reading the first bullet point (I've bolded the important stuff, for me at least)...

System management tasks such as managing the FDHOST Launcher service (MSSQLFDLauncher), restarting filter daemon host process if you change the service account credentials, configuring server-wide full-text properties, and backing up full-text catalogs...

Restarting the daemon, got me going. Man, that was easy. :D

Answer 3

i have the same problem first the "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)" Service was down, but even after starting it i am still in state as the image above ( i did the rest of the step as maintained above) http://docs.google.com/a/delorenzodesign.com/File?id=dgr4q2dh%5F25sq4dnxd9%5Fb

any idea? Thanks Peleg

Answer 4

I had a database that was migrated from a previous version of SQL Server to SQL Server 2008. It didn't have fulltext indexing enabled before the migration. In order to enable SQL Management Studio fulltext options, I had to issue the following commands:

use [your_database_name]

CREATE FULLTEXT CATALOG ftCatalog AS DEFAULT;
GO

EXEC [your_database_name].[dbo].[sp_fulltext_database] @action = 'enable'
GO

The first command creates the full text catalog. The second initializes fulltext indexing and tells Management Studio that fulltext is enabled on the specified database.