How to determine if an instance of SQL Server is case sensitive or not

How can I find out if an instance of SQL Server 2005 allows case sensitive databases or not?

By case sensitive, I mean case sensitivity of the objects in the database, i.e. the following two statements are not equivalent:

  • What is the purpose of system table master..spt_values and what are the meanings of its values?
  • Get the return value of date diff?
  • The TCP/IP connection to the host localhost, port 1433 has failed error, need assistance
  • Query an XML based on a column value in SQL
  • Cannot revoke permission granted by other user
  • SQL Server 2008 - Add XML Declaration to XML Output
    SELECT * FROM table

    I’ve looked in the property pages of the server (in Management Studio) but I couldn’t see it.

    3 Solutions collect form web for “How to determine if an instance of SQL Server is case sensitive or not”

    SELECT DATABASEPROPERTYEX('DatabaseNameHere', 'Collation') SQLCollation;

    Returns “SQL_Latin1_General_CP1_CI_AS”, the CI is what indicates case insensitivity

    In Management studio, right click on Instance in the object explorer and then click on “properties” to see the server properties. In the “General” section look at the collation. The default case insensitive setting is SQL_Latin1_General_CP1_CI_AS. The case sensitive setting is Latin1_General_CS_AS.

    The collation of a database can be different to the server collation. There is no restriction.

    When you CREATE DATABASE, you specify it there or it assumes the collation of the model databases (which should be the server collation).

        DATABASEPROPERTYEX('MyDB', 'Collation'), 
        SERVERPROPERTY ('Collation')
    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.