Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gagani
Posting Yak Master
112 Posts |
 Posted - 2012-09-04 : 05:31:03
|
| I have the same databases in two different servers with different names. i have made some changes to the first database and is working fine. when i try to introduce the same changes in the other database and tried to use it, I am getting the error as"cannot resolve collation conflict for equal to operation".does anyone know about it? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-09-04 : 05:46:46
|
| Yes, you have set the default collation differently between the servers, you can either change the collatin of the database and fields, or in your query use the COLLATE keyword on your joins and pick one. |
 |
|
|
gagani
Posting Yak Master
112 Posts |
Posted - 2012-09-04 : 05:50:47
|
| how to change the collation of database and fields? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-09-04 : 05:58:18
|
| http://msdn.microsoft.com/en-us/library/ms179254.aspx |
|
|
|
|
|
|
"cannot resolve collation conflict for equal to op