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 |
|
raveekumarg
Starting Member
36 Posts |
 Posted - 2008-11-18 : 04:09:33
|
| hiwhile trying to alter a procedure or execute it is throwing error msg as "Server: Msg 446, Level 16, State 9, Procedure "<procname>", Line 56Cannot resolve collation conflict for equal to operation"... how to overcomeravi |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-11-18 : 07:35:08
|
| Use COLLATE DATABASE_DEFAULT keyword |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-11-18 : 08:54:40
|
| As sakets_2000 has suggested:your sp is making some sort of string comparison (at line 56)Check the code of the sp and use a collation (case sensitivity - accent sensitivity) as appropriate. DATABASE_DEFAULT is probably what you want.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
alter procedure