23

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?

Alex Angas
  • 2,057

4 Answers4

26
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) 
    PRINT 'INSTALLED' 
ELSE 
    PRINT 'NOT INSTALLED'

(SQL Server 2005)

MSDN reference here.

TotPeRo
  • 103
19

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
Devraj Gadhavi
  • 306
5

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.

squillman
  • 38,163
-2

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.

HK_
  • 417