How to identify the "Full-Text search Installed or Not" on your current instance of SQL Server ?

 Posted by PandianS on 9/16/2010 | Category: Sql Server Interview questions | Views: 2449 | Points: 40
Answer:

SELECT CASE [Full-Text Search] WHEN 1 THEN 'Full-Text Search Installed' ELSE 'Full-Text Search Not Installed' END 'Status' FROM 

(
SELECT SERVERPROPERTY('IsFullTextInstalled') 'Full-Text Search'
) AS X


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response