Skip to content
  • There are no suggestions because the search field is empty.

SQL Script to Determine if the Database has Full Text Search Installed

Run the SQL Script below to determine if Full Text Search is installed on the database.

SELECT
 
CASE
 
WHEN
 
FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1
 
THEN
 
'INSTALLED'
 
ELSE
 
'NOT INSTALLED'
 
END IsFullTextInstalled