Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Collation conflict between SQL 2012 SP1 and SQL 2005 SP3 ? RE: Collation conflict between SQL 2012 SP1 and SQL 2005 SP3 ?

  • February 15, 2013 at 6:20 am

    #1588283

    Lynn Pettis (2/15/2013)

    Jan Van der Eecken (2/15/2013)

    Mark, did you copy and paste the error message directly from SSMS? If yes, then they are indeed different. Just look closely, the one is Latin1_General_CI_AS, and the other one is SQL_Latin1_General_CP1_CI_AS (note the CP1 part).

    Even more of a difference than that, one is a windows collation and the other a SQL collation.

    :w00t:

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]