Hi guys,
I have a small issue with collation. I tried to add stored procedure aspnet_UsersInRoles_AddUsersToRoles manually when i notice while copying the database it didnt got copied some how dont know why. but when i manually tried to create stored procedure the this error showed up:
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
for number of sql statements. I have also seen the few options in google manually add SQL_Latin1_General_CP1_CI_AS will fix gthe problem. But I have also seen the Collation option in SERVERGRID MSSQL TOOLS where you can set the collation. Can anyone suggest which way to go forward or any alternative ways. Thanks for all the help in advance
Sonu