If you want to determine the Collation setting for a particular database in SQL Server:
- Open Query Analyzer (or SQL Management Studio)
- Select your database
- Execute the following query:
SELECT DATABASEPROPERTYEX(db_name(), 'Collation') SQLCollation;
Hope this helps.