SQL 2008 Full-text index Add button is disabled!

less than 1 minute read

I restored an SQL 2000 database to sql 2008 server, upgraded etc, but the Full-text index menu uption is disable, obviously full-text indexing is always on in SQL 2008 but the MS Studio looks like using options from the past so to check if this is the case for you run this:

select name, is_fulltext_enabled from sys.databases

to configure it as it should be run this:

sp_fulltext_database 'enable'

Done!