Folks,
I have tried everything I can think of so I'm hoping someone in this forum can come to the rescue. Here is my situation:
I have a SQL database that has the ASP.NET 2.0 membership, roles, personalization etc. All of this works ok on my development server/SQL. On my production SQL however I am having a problem with just 1 stored procedure: aspnet_UsersInRoles_AddUsersToRoles.
When my code calls Roles.AddUserToRole I end up getting an exception thrown that says:
"Cannot resolve collation conflict for equal to operation."
I also get this message to appear if I go into Enterprise Manager on the live SQL, open the stored procedure aspnet_UsersInRoles_AddUsersToRoles and then click on "Check Syntax".
Default Collation on the live Sql is Latin1_General_CI_AS
Default Collation on the development Sql box is Sql_Latin1_General_CP1_CI_AS
I have tried changing the coll ...
Go to the complete details ...