Update error?

[Mike John]

One way or the other oldfield and oldaccount are defined with a different collation. This could be because the databases were created with different collations, or the tables specifically. Either way you can check via sp_help on each table and you should see that the collation clause is different.

To get round it either alter one of the tables to match the other (It would seem doubtful that they should really be different) or add a COLLATE clause on the where clause specifying the collation you want it to use for the comparison.

Mike John


"Lee" <lalcantara@schools.org> wrote in message news:00a201c3470c$6516f990$a501280a@phx.gbl...

> Hi,
>
> Hi, do you know what this error means. I looked it up in
> knowledge base, but could not find anything related.
>
> Error:
> Server: Msg 446, Level 16, State 9, Line 1
> Cannot resolve collation conflict for equal to operation.
>
> This is the SQL statement I ran:
> update DB1.sysop.oldTable
> set oldfield = newaccount
> from DB1.sysop.oldtable oldfield
> join DB2.dbo.newtable newaccount on oldaccount = oldfield
>
> Thanks
> Lee

[Lee]

Thanks guys, your information was very helpful.