Database
      Back to home
      1. IMS Knowledge Base
      2. FileBound
      3. Database

      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