Troubleshooting
Published 26 June 2013
Common issues
- SQL Compare shows identical objects as different
- Comparison seems slow
- Errors in scripts folders
- Can't compare encrypted text in SQL Server 2005 or 2008
- 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
