How can we help you today? How can we help you today?

Cannot resolve collation conflict for equal to operation

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

Comments

2 comments

Sort by
  • James Moore
    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
    0
  • petey
    What is the collation used for the master, tempdb and msdb tables respectively?
    petey
    0

Add comment

Please sign in to leave a comment.