Is recommended the SQL_Latin1_General_CP1_CI_AS server collation for a new SQL 2008 R2 instance?

• gregorio.hakimian

  Grasshopper

  Points: 21

  More actions

  September 14, 2010 at 1:19 pm

  #226881

  Hi, in our company, we have various prod instances of Sql Server 2000 with the SQL_Latin1_General_CP1_CI_AS server collation. Now, we are installing a couple of new servers with Sql Server 2008 R2.

  I saw that this class of collation is old style and is only for backward compatibility. What collation should I use for maintaining the compatibility between databases and servers from both versions?

  Thanks in advance

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  September 14, 2010 at 1:32 pm

  #1220933

  SQL_Latin1_General_CP1_CI_AS is the default collation for SQL Server 2008. Not sure how it is termed as "for backward compatibility"

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga