FTS in sql 2005

Question

Can somebody please, let me know that how do we find that full text search is enabled in SQL 2005.

Answer 1

See if the SQL Server FullText Indexing service is running.

After that, you have to create a catalog for the database and then the fulltext indexes on the relevant columns.

For more information, refer to the documentation: http://msdn.microsoft.com/en-us/library/ms142497%28SQL.90%29.aspx

Answer 2

SELECT SERVERPROPERTY('IsFullTextInstalled') will return 0/1 if is installed (Instance wide).

SELECT is_fulltext_enabled FROM sys.databases WHERE database_id = DB_ID() will return 0/1 if is enabled in current database.