How can we tell if our SQL-Server has Text Search enabled?

  • Questions
  • How can we tell if our SQL-Server has Text Search enabled?
Question ID: 105371
0
0

I’m, not sure if we enabled the component for text search on our install of SQL-Server, how can we tell if it is enabled?

Marked as spam
Posted by (Questions: 79, Answers: 4)
Asked on April 28, 2014 9:22 pm
6 views
Answers (1)
0
Private answer

To see if SQL-Server has Text Search installed at all:

Open SQL-Server Management Studio and then click NEW QUERY.

Execute this query:
select SERVERPROPERTY('IsFullTextInstalled') as textSearch

You should see a table as the result.
A ''1'' means Text search IS installed.

Marked as spam
Posted by (Questions: 3, Answers: 476)
Answered on April 28, 2014 9:23 pm