21

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

16

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
25
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .