Options

Cannot resolve collation conflict for equal to operation

dineshasankadineshasanka Posts: 208
edited April 21, 2006 12:04PM in SQL Backup Previous Versions
I am using SQL Backup 4.1.0.207
I upgrade it to previous version. Now I am getting error Cannot resolve collation conflict for equal to operation. for one server. Other two servers are working fine. Earlier all the three servers are working fine
· Share on Twitter

Comments

  • Options
    James MooreJames Moore Posts: 252
    This error seems to be related to SQL Server Collations and having different collations across two tables you are trying to join. I'm not sure why SQL Backup would cause this problem however you might want to look at http://www.ssw.com.au/SSW/KB/KB.aspx?KBID=Q211874 and see if it resolves the issue for you.

    If not please repost here and also post the statement which is generating this error.

    Many thanks,

    - James
    --
    James Moore
    Red Gate Software
    James Moore
    Head of DBA Tools
    Red Gate Software Ltd
    · Share on Twitter
  • Options
    peteypetey Posts: 2,358 New member
    What is the collation used for the master, tempdb and msdb tables respectively?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.