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.

(more…)

If you want to determine the Collation setting for a particular database in SQL Server:

1. Open Query Analyzer (or SQL Management Studio)
2. Select your database
3. Execute the following query:

SELECT DATABASEPROPERTYEX(db_name(), 'Collation') SQLCollation;
Hope this helps.

I have needed to check my SQL Server Collation settings recently. Here is a SQL Query to find your server’s collation setting.
SELECT SERVERPROPERTY('Collation') AS 'Collation'
Hope this helps.