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 Serve
r, 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 y
ou don't, you inherit
what you selected when you installed. This collation is the default collatio
n for the database.
When you create a table, you can at the column level specify collation. If y
ou 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.googlegroup
s.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?
>|||In 2005 is their a way of resetting the server value after it has been
installed?
Tibor Karaszi wrote:[vbcol=seagreen]
> Case sensitivity are determined by the collation. When you install SQL Ser
ver, 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 collat
ion 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@.e3g2
000cwe.googlegroups.com...|||You have to rebuild the system database, which mean that all information in
the system databases are
lost. Use setup.exe for this (details in Books Online). Then you have to att
ach or restore all user
databases, and of course detach or backup those first. The user databases wi
ll have the same
collation as before the rebuild.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<robin9876@.hotmail.com> wrote in message news:1161877957.117735.3190@.f16g2000cwb.googlegroup
s.com...
> In 2005 is their a way of resetting the server value after it has been
> installed?
> Tibor Karaszi wrote:
>