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 |
|
codrgiii
Starting Member
29 Posts |
 Posted - 2009-06-17 : 11:20:45
|
I had sql server 2005 and upgraded using SQL 2008 and now i'm getting this errorCannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation., SQL state 37000 in SQLExecDirect How do i fix this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-17 : 11:22:31
|
| use COLLATE clause to explicitly use the required collation for your column. check both columns involved in equality operation and overrides ones collation to make it same as other |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-06-17 : 11:24:56
|
| Check the collation of the system databases and user databases and character columns.You might want to change it as it will probably continue to cause problems.Might want to redo the migration.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
SQL PROBLEM !!