Troubleshooting
Published 04 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
- Deploying a SQL 2000 compatible database from a SQL 2005 database using SQL Compare
- When does the deployment process rebuild tables?
Error messages
- A duplicate object name has been found
- HTML reports are generated for identical comparisons
- 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
