[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 Using T-SQL for Full-text Indexing
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.