How do I check the Default Server Collation (case-sensitivity) of a SQL Server installation?

June 6, 2008 at 11:27 pm Leave a comment

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.

Advertisements

Entry filed under: SQL Scripts. Tags: , , , , , , .

How do I list all Primary Keys in a SQL Server 2000/2005 database? How do I pad an Integer to 4 digits with leading zeros?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Calendar

June 2008
M T W T F S S
    Jul »
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Archives

Blog Stats

  • 32,506 hits

%d bloggers like this: