SQL_Latin1_General error

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?