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 |
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-06-03 : 10:02:13
|
Hi Gurus,Iam facing following issue while selecting data from one of my database.Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP850_BIN" in the equal to operation.Msg 4413, Level 16, State 1, Line 1Its just a select * from database.table query.can someone please help me in this..Thanks,ServerTeam |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-03 : 10:07:24
|
What is the actual query? I am guessing the database you are running the query from has a different collation to the target. |
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-06-03 : 10:12:18
|
iam select view..which has database with diff collation.Thanks,ServerTeam |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-03 : 10:42:08
|
Try this:http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/ |
|
|
mdubey
Posting Yak Master
133 Posts |
|
|
|
|