Fulltext index disabled -- when & why?

Brian Donahue

Hi K,

Can you please send the script the SQL Compare produced to
support@red-gate.com? This might tell us why the full text capability was
disabled for your database. I don't know specifically which conditions cause
this to happen, but the script should enable and rebuild the catalogs for
you if it's disabled them in the first place!

Regards,

Brian Donahue
Red Gate Technical Support

"K Kelley" <kkelleyNOSPAM@dmr-inc.com> wrote in message
news:wqIks%23fLEHA.1428@server53...
> While running a SQL Compare script, noticed that the generated script was
> running [EXEC sp_fulltext_database 'disable'] but never re-enabling.
After
> running the script, sure enough, my fulltext catalog was disabled and I
had
> to manually re-enable and repopulate to get the fulltext index functioning
> again.
>
> Two questions:
> 1) Why does the script disable but not re-enable?
> 2) What condition exists which cause the [sp_fulltext_database 'disable']
> statement to be included?
>
> Thanks.
> K Kelley
>
>

Brian Donahue

If the source database has fulltext disabled and the target has it enabled, the fulltext property for the database will become disabled if there are any fulltext catalogs to drop.

We are looking into fixing this now.