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