Archive for February 18th, 2008

Selecting “SQL_Latin1_General_CP1_CI_AS” Collation in SQL Server

Monday, February 18th, 2008

Recently, I have had to install a named instance of SQL Server 2005 along side a default instance of SQL Server 2000. The 2000 server had the following collation configured: SQL_Latin1_General_CP1_CI_AS. For testing purposes, we had to make sure the new instance had the same collation setting.