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 |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2012-05-02 : 05:37:35
|
| hi,when am trying to add a new user using management studio from the database iam in, am getting error <446: cannot resolve collation conflict for equal to operation>and am getting this error for all the databases am trying to users to.note: the databases collation is the same as the master collationpls. help |
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2012-05-02 : 10:25:16
|
| [code]You need to resole the collation issue first .This Link might help you.http://msdn.microsoft.com/en-us/library/aa214328%28v=sql.80%29.aspx [/code] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-02 : 19:30:49
|
| are you using t-sql command or using wizard------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ann06
Posting Yak Master
171 Posts |
Posted - 2012-05-03 : 04:05:30
|
| am using the wizard to add users, my database collations are as follows:MYDB:SQL_LATIN1_GENERAL_CP1256_CI_ASOTHERDB:SQL_LATIN1_GENERAL_CP1256_CI_ASMASTER:SQL_LATIN1_GENERAL_CP1256_CI_ASMSDB:SQL_LATIN1_GENERAL_CP1256_CI_ASMODEL:SQL_LATIN1_GENERAL_CP1_CI_ASand this problem is new on the same databases |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-03 : 14:48:04
|
| try changing collation of model db to match the others------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Not able to add new user in a database !!