[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

USE is case sensitive?

Michael She

3/9/2007 9:51:00 PM

Hi all,

We loaded our DB onto a customer database and we noticed that certain
commands (i.e. USE DATABASE) is case sensitive. On our internal DBs,
this is not that case.

Does anyone know what flag we can set to disable case sensitivity?

Thanks!
3 Answers

Stefan

3/9/2007 10:41:00 PM

0

Check the collation of the master database. Whoever installed SQL Server selected a case-sensitive collation:

select serverproperty('Collation')

The only way to change it is to rebuild the master database, which effectively starts your SQL Server from scratch:

http://msdn2.microsoft.com/en-us/librar...(SQL.80).aspx
and
http://msdn2.microsoft.com/en-us/library/ms1... (scroll to Specifying a New System Collation)

--
Cheers,
Stefan Delmarco

http://www.f...

David Portas

3/9/2007 10:49:00 PM

0

On 9 Mar, 21:50, "Michael She" <michael....@gmail.com> wrote:
> Hi all,
>
> We loaded our DB onto a customer database and we noticed that certain
> commands (i.e. USE DATABASE) is case sensitive. On our internal DBs,
> this is not that case.
>
> Does anyone know what flag we can set to disable case sensitivity?
>
> Thanks!

That is determined by the server collation setting. Changing the
server collation requires running SETUP and rebuilding the system
databases. You should not undertake that change unless you are sure of
the impact on any other databases or applications using that server.

http://msdn2.microsoft.com/en-us/library/ms1...

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/librar...(en-US,SQL.90).aspx
--

Edwin Hurwitz

12/3/2011 6:23:00 PM

0

In article
<549d0199-c25e-490b-b32c-28200c19405c@ca1g2000vbb.googlegroups.com>,
Ed Chapin <edchapin01@hotmail.com> wrote:

> On Dec 2, 3:35?pm, "3jane." <q3j...@yahoo.com> wrote:
> > On Dec 1, 11:19?pm, bzl...@aaool.com wrote:
> >
> > > Being the shopaholic that I am, I stumbled upon Vol. 1 on Amazon on
> > > Black Friday, got it at a good price, $28 or something. ?It arrived
> > > yesterday. ?Totally killer!! ?Great audio quality. ?I briefly peeped
> > > the DVD, and it's real nice, too. ?Looking forward to the rest of this
> > > series. ?There's never enough quality Miles...
> >
> > >http://www.amazon.com/gp/product/B005ARYEY6/ref=ox_sc_act_i......
> >
> > I just inherited at least a dozen Miles CDs, none of which I've
> > listened to yet but all of which I'm looking forward to. ?I prefer the
> > live stuff.
>
> Perhaps you will stumble upon a recording of the night the good
> ambassador whisked Miles through the cover of darkness for a
> clandestine moonlight gig in a Jiangsu mulberry grove.
>
> Perhaps they will melt after you listen to them once--after they etch
> into the rhythm of your naive, unsuspecting hippie psyche an elaborate
> plot of world domination disguised as a box of licorice and cast
> widely across the sacred lake of Muhambala.
>
> Or, perhaps not.
>
> Ed

Hey, pass that over here, willya? I need a hit!