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.