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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!