Cannot resolve collation conflict for equal to Operation

Cannot resolve collation conflict for equal to Operation

Again, when I used aspnet_regsql to create a database that provides services such as membership, I met again.
What should I do? Very troublesome !!! This is the problem of collation conflict every time.
First, the collation of the database for which I want to create services such as membership is SQL _latin1_general_cp1_ci_as, and the default value of SQL Server is chinese_prc_ci_as.
I think this is basically the case.

I decided to modify the SQL file used by the original aspnet_regsql.
The original SQL file does not contain collation. I add collate database_default to each character data type field.
But these are generally used in the SELECT statement.

This is not the case. Otherwise, the world will be messy. I used alter database [dB name] collate chinese_prc_ci_as to change the collation of the original database to the same as the collaction of SQL Server.

Reference:
Http://www.umachandar.com/technical/SQL2000Scripts/Main10.htm
Http://www.umachandar.com/technical/SQL2000Scripts/UtilitySPs/Main8.htm