Please find the SQL Query to find if Full-Text Indexing is enabled in SQL Server
SELECT
CASE WHEN FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1
THEN
'INSTALLED'
ELSE
'NOT INSTALLED'
END IsFullTextInstalled;
CASE WHEN FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1
THEN
'INSTALLED'
ELSE
'NOT INSTALLED'
END IsFullTextInstalled;
Please find an alternated SQL query as follows:
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
Print 'INSTALLED'
Else
Print 'NOT INSTALLED';
Print 'INSTALLED'
Else
Print 'NOT INSTALLED';
Reference: FULLTEXTSERVICEPROPERTY (Transact-SQL)
Other MS Article:
Enable a Database for Full-Text Indexing (SQL Server Management Studio)
No comments:
Post a Comment