18

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?

4 Answers 4

13

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
23

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

(SQL Server 2005)

MSDN reference here.

1
  • 2
    FYI - In the event anybody else is wondering, this still works in 2014. Apr 20, 2015 at 19:41
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.

1
  • 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, 2009 at 16:01
-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.

2
  • Hmmm... does that actually tell me if the feature is installed?
    – Alex Angas
    Jun 29, 2009 at 11:55
  • 1
    This doesn't answer the question in any way.
    – webnoob
    Apr 10, 2012 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.