Search This Blog

December 28, 2007

Sql Server - Collation

How to know the collation of a database?

Execute the following sql statement by changing the DataBase_Name.


SELECT DATABASEPROPERTYEX( 'DataBase_Name' , 'Collation' ) AS DatabaseCollation

How to know the collation of Sql Server?


SELECT SERVERPROPERTY('Collation') AS ServerCollation

No comments: