How can I set for COLLATION for stored procedure as Database default rather than individual column of tables in that procedure .
Cannot resolve the collation conflict between “SQL_Latin1_General_Pref_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation
I am getting collation conflict error as database server collation is different from database collation. The procedure is huge and I don't know on which table column conflict is occuring.
Is it even possible to assign collation for stored procedure such that all columns in that procedure have same collation? Plz plz plz plz help.