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.
Thank you so much. Your “just one-off” information has been usefull to someone – me;) .
You have just saved me from installing and uninstalling SQL Server until I got the correct SQL Collation settings.
So thanx again
Elroy
This info was really useful for me too.
Thanks!
Again, very helpful. I’ve been trying, without much success, to find this specific information elsewhere.
THANK YOU!! Glad you posted it, was very helpful to me also