Error message when running datacompare

Brian DonahueBrian Donahue Posts: 6,590 New member
Hi Chris,

Thanks for your enquiry. My name is Brian Donahue and I am a support
engineer with Red Gate Software. The problem you describe could be caused by
the collation order on one or more of the columns of the table in one
database being different than in the other database. It's probably in your
best interest to make sure that the collation order is the same as in the
database default.

Right-click on your database in Enterprise Manager and note the
collation order.

Script the offending table using Query Analyzer. (or SQL Compare...)
Look for differing collation order statements and correct them so the
collation order is the same in both databases:
CREATE TABLE [CustomerInfo] (
[Cust_ID] [int] IDENTITY (1, 1) NOT NULL ,
[FirstName] [varchar] (255) COLLATE
French_CI_AS NULL , /* change this to Latin1 */
[LastName] [varchar] (255) COLLATE
Latin1_General_CI_AS NULL ,
[Address_1] [varchar] (255) COLLATE
Latin1_General_CI_AS NULL ,...

If this doesn't solve your problem, please let me know. I'm happy to

Brian Donahue

"Chris Scott" <[email protected]> wrote in message
news:[email protected]
> Hi,
> I am getting the following error message when comparing most of the tables
> in my two databases. They both have exactly the same schema.
> The error is:
> This object cannot be viewed as an error occured during the compare
> Error comparing [dbo].[REP_DAILY_TOTALS]
> [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot resolve collation
> conflict for UNION operation.
> If anyone can tell me what this error means and how to fix the problem, I
> would appreciate it.
> Thanks, Chris.
This discussion has been closed.