Removing case sensitivity

Is there a way to remove Case Sensitivity from a SQL 2000 server? I can't
imagine why anyone would set the server to this but one of my vendors did and
I hate needing to know exactly where to put my caps...
TIA,
Joe
This should help :-
http://support.microsoft.com/default...b;en-us;325335
HTH. Ryan
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:068ACE9B-3F12-4ED0-926A-8826B059CA3D@.microsoft.com...
> Is there a way to remove Case Sensitivity from a SQL 2000 server? I can't
> imagine why anyone would set the server to this but one of my vendors did
> and
> I hate needing to know exactly where to put my caps...
> TIA,
> Joe
>
|||"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:068ACE9B-3F12-4ED0-926A-8826B059CA3D@.microsoft.com...
> Is there a way to remove Case Sensitivity from a SQL 2000 server? I can't
> imagine why anyone would set the server to this but one of my vendors did
> and
> I hate needing to know exactly where to put my caps...
> TIA,
> Joe
>
Case sensitive db's can be faster. ;-)
You don't have to figure out whether or not Apple = APPLE = ApPle etc. You
can do a simple binary compare.
Rick Sawtell
MCT, MCSD, MCDBA
|||Thank you I will check this out.
From a quick look it seems like I have to rebuild the SQL server for this?
Thanks Again,
Joe
"Ryan" wrote:

> This should help :-
> http://support.microsoft.com/default...b;en-us;325335
> --
> HTH. Ryan
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:068ACE9B-3F12-4ED0-926A-8826B059CA3D@.microsoft.com...
>
>
|||Yes you are correct, but when I have a query "select * from apple_tbl" I get
an error saying the object does not exist becuase it is spelled apple_Tbl.
How do you get around every query and SP you write?
Thanks for the response,
Joe
"Rick Sawtell" wrote:

> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:068ACE9B-3F12-4ED0-926A-8826B059CA3D@.microsoft.com...
> Case sensitive db's can be faster. ;-)
> You don't have to figure out whether or not Apple = APPLE = ApPle etc. You
> can do a simple binary compare.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Afraid so..
HTH. Ryan
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:819D50DF-DF8A-49CE-B6D2-17E822F8A742@.microsoft.com...[vbcol=seagreen]
> Thank you I will check this out.
> From a quick look it seems like I have to rebuild the SQL server for this?
> Thanks Again,
> Joe
>
> "Ryan" wrote:
|||jaylou wrote:
> Yes you are correct, but when I have a query "select * from
> apple_tbl" I get an error saying the object does not exist becuase it
> is spelled apple_Tbl.
> How do you get around every query and SP you write?
>
You do not have to reinstall SQL Server to change a database collation.
You can create a new database with the correct collation and then
migrate the data. System tables in master will still be case sensitive.
You can also change the database collation directly and then copy the
tables in the database (changing the collation does not change the
collation of existing objects)
-- for example
alter database MyDB
COLLATE SQL_Latin1_General_CP1_CI_AS
You could also rename your objects in the existing database to use
lower-case to avoid these issues. While the standard has moved away from
case-sensitive collations, I do think they offer some advantages since
they keep object names capitalized the same in the database.
David Gugick - SQL Server MVP
Quest Software
|||and some of us hate when applications are written that don't use the correct
case and barf on case-sensitive servers ;)
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:2FD17568-400F-40DD-953A-D0181683761E@.microsoft.com...[vbcol=seagreen]
> Yes you are correct, but when I have a query "select * from apple_tbl" I
> get
> an error saying the object does not exist becuase it is spelled apple_Tbl.
> How do you get around every query and SP you write?
> Thanks for the response,
> Joe
> "Rick Sawtell" wrote: