Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

4 Answers 4

up vote 2 down vote accepted

I like SELECT over PRINT

So here is my take on this

             FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1 
              'NOT INSTALLED' 
    END IsFullTextInstalled
share|improve this answer

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

(SQL Server 2005)

MSDN reference here.

share|improve this answer
FYI - In the event anybody else is wondering, this still works in 2014. – John MacIntyre Apr 20 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.

share|improve this answer
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.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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