Showing posts with label Microsoft SQL Server. Show all posts
Showing posts with label Microsoft SQL Server. Show all posts

Monday, 27 June 2022

SQL Query to find if Full-Text Indexing is enabled in SQL Server

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;

Please find an alternated SQL query as follows:

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
Print 'INSTALLED'
Else
Print 'NOT INSTALLED';

Reference: FULLTEXTSERVICEPROPERTY (Transact-SQL)

Other MS Article:
 Enable a Database for Full-Text Indexing (SQL Server Management Studio)

What's new in Microsoft Intune: April 2025

Microsoft Intune's April 2025 release introduces several enhancements aimed at improving device management and security: Custom Naming ...