What are the challenges you face when working across database platforms? Take the survey

Fulltext index disabled -- when & why?

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 25, 2005 10:58AM in SQL Compare Previous Versions
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!


Brian Donahue
Red Gate Technical Support

"K Kelley" <kkelleyNOSPAM@dmr-inc.com> wrote in message
> While running a SQL Compare script, noticed that the generated script was
> running [EXEC sp_fulltext_database 'disable'] but never re-enabling.
> running the script, sure enough, my fulltext catalog was disabled and I
> 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


  • Options
    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.
This discussion has been closed.