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: 91, Answers: 5)
Asked on April 28, 2014 9:22 pm
43 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: 4, Answers: 509)
Answered on April 28, 2014 9:23 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top