How to Detect If Full-Text Search is Enabled on a SQL Server Database

To detect if the ‘Full Text Search’ feature is enabled on your database, use this query:

USE AdventureWorks
SELECT is_fulltext_enabled
FROM sys.databases
WHERE database_id = DB_ID()

If Full-Text Search is enabled, the query returns 1, else the query returns 0 if it is not

Here’s the output after running the query on a database which has Full-Text Search enabled