Using Transact-SQL for Full-text Indexing in SQL Server 2005
The next t-sql statement indicates whether a database has been enabled for full-text indexing.
SELECT DATABASEPROPERTY('puthereDBname', 'IsFulltextEnabled')
A result of 1 means the database is enabled.
If you would like to ask for the current database, use the following statement
SELECT DATABASEPROPERTY (db_name(db_id()),'Is FulltextEnabled')
The following statement verifies that Microsoft Full-Text Engine for SQL Server service is installed.
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
-- Put your code here
If you would like to enable full-text search on a specific database use this statement
EXEC [puthereDBname].[dbo].[sp_fulltext_database] @action = 'enable'
Finally, to remove all catalogs from a database or disable full-text indexing for that database execute the following statement
EXEC [puthereDBname].[dbo].[sp_fulltext_database] @action = 'disable'
.Send mail to
questions or comments about this web site.