How to detect if full text search is installed in SQL Server

Question

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?

score 23 · Answer 1 · edited May 20 '13 at 14:24

23

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

(SQL Server 2005)

MSDN reference here.

edited May 20 '13 at 14:24

Alberto De Caro

103
4

answered Feb 03 '10 at 11:20

2

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

score 13 · Accepted Answer · answered Apr 21 '15 at 12: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

score 5 · Answer 3 · answered Jun 29 '09 at 14:43

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.

answered Jun 29 '09 at 14:43

squillman

37,618
10
90
145

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

score -2 · Answer 4 · answered Jun 29 '09 at 11:30

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

answered Jun 29 '09 at 11:30

HK_

407
2
5

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

How to detect if full text search is installed in SQL Server

4 Answers4