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'))

        BEGIN

                -- Put your code here

        END

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 webmaster@sqlcoffee.com with questions or comments about this web site.