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.

To ensure this, we selected the following during the installation process.

“Dictionary order, case-insensitive, for use with 1252 character set” with “Latin1_General”

I know this is just one-off information, but it may be useful to someone.