Home / server / Questions / 33159
Accepted
Alex Angas
Asked: 2009-06-30 02:06:02 +0800 CST

How to detect if full text search is installed in SQL Server

  • 772

I need to find out if full text search is installed on SQL Server 2005. I don't have permission to log into the box and fire up Setup to check. However I can run SQL Server Management Studio and connect to run queries with sysadmin permissions.

Does anyone know how to detect if this feature is installed?

sql-server full-text-search

4 Answers

  1. IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) print 'INSTALLED' else print 'NOT INSTALLED'

    (SQL Server 2005)

    MSDN reference here.

    • 23
  2. Best Answer

    I like SELECT over PRINT

    So here is my take on this

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

  3. Look at the list of services on the machine. If full text search is installed you'll see a service named SQL Server FullText Search ([instance]) where [instance] will be the name of the SQL instance that it is associated with.

    • 5

  4. If you have sql server management studio, you should be able to find out following the steps this MSDN article. If you find it already checked, then its enabled.

    • -2