Determine SQL Database Collation Setting

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.