I have created the .bak
file from my local database (MSSQL SERVER 2012) and restored it on live server (MSSQL Server 2012). It is working but some the stored_procedures
are not executing and are generating error:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation
I do not have any idea what this error is and how to resolve it?
I have thousands of stored_procedures.How to resolve this issue in all stored procedures?
Aucun commentaire:
Enregistrer un commentaire