What are the challenges you face when working across database platforms? Take the survey

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
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


  • Options
    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
  • 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
Sign In or Register to comment.