Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Exclamation Unanswered: Cannot resolve collation conflict for equal to operation

    We have loaded a db from a different SQL Server, and now we are trying to recreate some stored procedures. Some procs experience the error "Cannot resolve collation conflict for equal to operation ".

    Can we simply create a new db on our target Sql Server, create the tables w/ the default collation sequence, and then use DTS to pull the data and populate the new db? Will this pull the data and store it in the desired collation? Seems like it should - let me know if it will/will not work, or if there's an easier way. Thanks!

  2. #2
    Join Date
    Aug 2002
    Posts
    2

    Re: Cannot resolve collation conflict for equal to operation

    apparently the default collation of your sql server is not the same as the one from which you loaded the data. you can create a new database with the collation being the same as the one that of the server from which you are getting your data. and your new database will work without you changing anything!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •