Home Forums SQL Server 2008 SQL Server 2008 - General Msg 468, Level 16, State 9, Procedure "procedurename", Line 129 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. RE: Msg 468, Level 16, State 9, Procedure "procedurename", Line 129 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

  • April 13, 2012 at 8:25 am

    #1473274

    Thank you for all your advice!

    I used COLLATE DATABASE_DEFAULT and it worked:

    Table1.Column1 COLLATE DATABASE_DEFAULT = Table2.Column1 COLLATE DATABASE_DEFAULT

    Thank you everyone for you advice!