Troubleshooting
Published 21 August 2019
Common issues
- Comparison seems slow
- Errors in scripts folders
- HTML reports are generated for identical comparisons
- Rollback on script failure or cancellation
- SQL Compare may drop and create CLR assemblies
- SQL Compare shows identical objects as different
- When does the deployment process rebuild tables?
Error messages
- A duplicate object name has been found
- Could not enlist in a distributed transaction
- Could not start a transaction for OLE DB provider
- Error Comparing DB1 vs DB2. Cannot insert the value NULL into column 'YourColumn', table 'database.dbo.tmp_rg_xx_MyTable'; column does not allow nulls. INSERT fails
- SQL Server doesn't exist or access is denied
- The DEFAULT_SCHEMA clause cannot be used with a Windows group or with principals mapped to certificates or asymmetric keys
- The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction...
- This SQL Server has been optimized for X concurrent queries. This limit has been exceeded by X queries and performance may be adversely affected
- User or role already exists in the current database / The login already has an account under a different user name
