Full-Text Index is grayed out

  • Hello Friends,

    I've just upgraded two servers from 2005 to 2008 and I'm getting ready to publish them just got one thing to do and surprise surprise something weird. When i right click on the table Full-Text Index it is grayed out. I've done some digging and found

    http://msdn.microsoft.com/en-us/library/ms403375.aspx

    And i quote 'In SQL Server 2008, all user-created databases are always full-text enabled and cannot be disabled.'

    Has anyone come across this before??

    Cheers 🙂

    Remember
    Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!

  • For those who are interested, the problem was because they full text catalog originates from a 2000 environment, you just need to go to Storage and either create a new Full-text catalog or just rebuild it.

    :smooooth:

    Remember
    Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply