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.