Home > IT Answers > Microsoft Windows > collation discrepancy issue
Tigerravi
5 pts.
 collation discrepancy issue
MSSQL 2005, Windows 7
how to fix the collation discrepancy issue while upgrading an application. In mssql 2005 database server, tried to create a database with windows authentication and manually provided sql authentication and ran three queries ALTER DATABASE djbadmin SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE djbadmin COLLATE Latin1_General_CI_AS ALTER DATABASE djbadmin SET MULTI_USER it showed like collation was same for server and as well as for database but when tried to upgrade on the server(application), it gave an error as "collation discrepancy" hence terminating the upgrade process.

Software/Hardware used:
mssql database server, standalone machine(windows 7)
ASKED: June 25, 2012  10:28 PM
UPDATED: June 26, 2012  11:43 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _