Friday, April 15, 2011

Do you want to detect is Full Text is enabled on SQL Server for your DB? Just a query

Easy to do:
SELECT
dtb.is_fulltext_enabled AS [IsFullTextEnabled]
FROM
master.sys.databases AS dtb
WHERE
(dtb.name='dml_sql_u_man')

The result of this query will give us a result if SQL Server has enabled full text

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)