Full Text Indexing

All user-created databases in SQL Server 2008 and later versions are always enabled for full-text indexing.


For previous versions we can find using below method,

SELECT DATABASEPROPERTYEX('DBNAME', 'IsFulltextEnabled');

Result :- 

1 = TRUE
0 = FALSE
NULL = Input not valid