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.googlegroups.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:
> 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.googlegroups.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?
> >|||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 attach or restore all user
databases, and of course detach or backup those first. The user databases will 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.googlegroups.com...
> In 2005 is their a way of resetting the server value after it has been
> installed?
> Tibor Karaszi wrote:
>> 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.googlegroups.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?
>> >
>