I have a Database on a Development Server with collation Settings
"SQL_Latin1_General_CP1_CI_AS" . Now i moved this Database to Newly installed Test Server. But Collation of the Test Server is "Latin1_General_CI_AI".
I am trying to execute the Stored Procedures with input parameters.
This is giving the following Error
"Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. "
So, as the collation is different ,i tried to change the collation of System Databases ( Master, Model. Temp, MSDB) to
It is not allowing to Alter that Collation changes.
Can anybody tell whether it is possible to change system Databases Collation or any other method to fix this problem.