Take the 2-minute tour ×
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

3 Answers 3

up vote 3 down vote accepted

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

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

(SQL Server 2005)

MSDN reference here.

share|improve this answer

Your Answer

 
discard

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.