SQL-Error--related to COLLATION.

Posted on 2006-05-24
Last Modified: 2010-04-17
I take a bachkup of my database from 1 serverand then restore it to another server, but now at new server some procedure of my database are not working properly , giving error that  " Cannot resolve collation conflict for equal to operation ”.
Thanks in advance .
Question by:Nish_since1981
    1 Comment
    LVL 142

    Accepted Solution

    this error means that you compare 2 values (ie 2 columns) that have a different collaction (ie collations that are not compatible.

    check the server, database, table and columns related to the query to find out which collation applies.

    to solve that: depends on what you can do and what differences there are.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    TextBlock Stops Updating 2 48
    Batch file output 20 71
    matchUp  challenge 9 51
    Excel object stays open 19 56
    This article will show, step by step, how to integrate R code into a R Sweave document
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now