Archive for February 15th, 2008

Determine SQL Database Collation Setting

Friday, February 15th, 2008

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.

Check SQL Collation Setting

Friday, February 15th, 2008

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.

Archives

Blogroll

RockinMedia