Articles
Sort by recent activity
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).
Full text objects can't be created inside transactions.
A SQL Chang...
The partition scheme [xxx] on table [yyy] was not found
1. Make sure the repository folder which the database is linked to is solely used by SQL Source Control for that database (it's important to not manually add anything to the folder unless for troub...
Full-Text Search is not installed, or a full-text component cannot be loaded
The Full-Text Search Is Not Installed, Or A Full-Text Component Cannot Be Loaded error usually occurs because SQL Change Automation uses, by default, SQL LocalDB to validate the scripts folder.
SQL...
The operation could not be performed because OLE DB provider ... for linked server ... was unable to begin a distributed transaction (SCA)
This error occurs because of the Transaction Isolation Level.
By default, SQL Change Automation for Powershell uses the Serializable Transaction Isolation Level, however this deployment requires a ...
Post-update schema check failed
This error can occur when Deploying a Database Release (which corresponds to the Use-DatabaseReleaseArtifact if using Powershell)
On this step, SQL Change Automation will deploy an update script ge...