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?


I like SELECT over PRINT

So here is my take on this

             FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1 
              'NOT INSTALLED' 
    END IsFullTextInstalled

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

(SQL Server 2005)

MSDN reference here.

  • 2
    FYI - In the event anybody else is wondering, this still works in 2014. – John MacIntyre Apr 20 '15 at 19:41

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.

  • I was able to connect to the SQL box through the Services MMC console and found the SQL Server FullText Search service there. – Alex Angas Jun 29 '09 at 16:01

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.

  • Hmmm... does that actually tell me if the feature is installed? – Alex Angas Jun 29 '09 at 11:55
  • 1
    This doesn't answer the question in any way. – webnoob Apr 10 '12 at 12:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.