When ASPNETForum returns the error as similar as follow:
Cannot resolve the collation conflict
between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in
the equal to operation.
You could mostly resolve it by trying to:
1) change database collation to SQL_Latin1_General_CP1_CI_AS via the control panel
2) connect the database, find stored procedure "Statistics_ResetTopPosters"
3) find and change the code from:
CREATE Table #Top500Users (
Rank int IDENTITY (1, 1) NOT NULL,
UserName nvarchar(50)
)
to:
CREATE Table #Top500Users (
Rank int IDENTITY (1, 1) NOT NULL,
UserName nvarchar(50) collate database_default
)
reference link:
http://forums.asp.net/535822/ShowPost.aspx