[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
SQL Server 2017
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.