Pages

Thursday, March 24, 2022

Is Full Text Installed in your SQL server

 SELECT 

    CASE 
         WHEN 
             FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1 
         THEN 
              'INSTALLED' 
         ELSE 
              'NOT INSTALLED' 
    END [Is Full Text Installed?]