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: 2218 | Points: 40

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