Determine SQL Database Collation Setting

By xerocube | February 15, 2008

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.

Topics: Code, SQL | No Comments »

Comments

Archives

Blogroll

RockinMedia