Disabling SQL 2005 Case Sensitive

In SQL 2005 is there a way of disabling the case sensitive option for
database objects and data criteria at the database or server level?
Case sensitivity are determined by the collation. When you install SQL Server, you specify a
collation, which:
Acts as default for a new database.
Is the collation for the system databases.
When you create a new database, you either define a collation or don't. If you don't, you inherit
what you selected when you installed. This collation is the default collation for the database.
When you create a table, you can at the column level specify collation. If you don't, you get the
database default collation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<robin9876@.hotmail.com> wrote in message news:1161686322.061321.14570@.e3g2000cwe.googlegrou ps.com...
> In SQL 2005 is there a way of disabling the case sensitive option for
> database objects and data criteria at the database or server level?
>