How to check if full-text querying is enabled for a database ?

xmldeveloper — Wed, 18 Jan 2006 13:55:45 GMT

Using DATABASEPROPERTY function and IsFullTextEnabled parameter.
CODE:

USE AdventureWorks;
GO
SELECT DATABASEPROPERTY('AdventureWorks', 'IsFullTextEnabled');
GO

REFERENCE: "Obtaining Full-Text Property Values using Transact-SQL Functions" http://msdn2.microsoft.com/ms142579.aspx

Full-Text Search