February 18th, 2008
Selecting “SQL_Latin1_General_CP1_CI_AS” Collation in SQL Server
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.