How do I check the Default Server Collation (case-sensitivity) of a SQL Server installation?
June 6, 2008
To check the Default Server Collation of a SQL Server installation, run the following SQL query:
sp_helpsort
You should get a result similar to this:
Note: To check the collation of a particular database, right click on the database in SQL Server Enterprise Manager (2000) or Management Studio (2005) and click Properties. The collation will be displayed in the Collation Name field.
Entry Filed under: SQL Scripts. Tags: case-sensitive, case-sensitivity, collation, database, database collation, default server collation, sp_helpsort.
Trackback this post | Subscribe to the comments via RSS Feed