Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'object_name' because it is not full-text indexed

By default SQL Change Automation deploys changes within a transaction (and it uses the SERIALIZABLE transaction isolation level).

This can cause issues with changes that can't be within the same transaction.

To workaround this issue you should use the NoTransactions SQL Compare option.

Please note that if you use this option there's no rollback if the deployment fails so it's advisable to isolate changes that require this change as much as possible and backup the targets before carrying out the change

Was this article helpful?

0 out of 0 found this helpful
Have more questions? Submit a request