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

case-sensitive, sql-server, sql-server-2005

Solution

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

Returns "SQL_Latin1_General_CP1_CI_AS", the CI is what indicates case insensitivity

Problem

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: ``` SELECT * FROM TABLE SELECT * FROM table ``` I've looked in the property pages of the server (in Management Studio) but I couldn't see it.

Original source