SQL Server and case sensitive instance

30 Sep 2005 7:07 PM

Alain

Hi,

I was under assumption that case sensitivity in SQL Server will be apply to
both
object data as well as identifiers (object names).
I've istalled the new case sensitivity instance and I'm able to create 02
databases with same name (in different case), but it does not work for
tables or SP (it returns "There is already an object named ..." message)
I'm looking for information that explains where the case sensitive is
applied and where not

Thank you for your help

30 Sep 2005 7:15 PM

Jerry Spivey

Alain,

Reguardless of the answer here I really would not recommend having
databases, tables and other objects with the SAME name - different case. I
would suspect this would become a programming nightmare over time.

HTH

Jerry
Show quote

"Alain" <A***@yahoo.com> wrote in message
news:e9fnzIfxFHA.3772@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I was under assumption that case sensitivity in SQL Server will be apply
> to
> both
> object data as well as identifiers (object names).
> I've istalled the new case sensitivity instance and I'm able to create 02
> databases with same name (in different case), but it does not work for
> tables or SP (it returns "There is already an object named ..." message)
> I'm looking for information that explains where the case sensitive is
> applied and where not
>
> Thank you for your help
>
>

1 Oct 2005 3:11 PM

Tibor Karaszi

I fully agree with Jerry. As for the immediate question, my guess is that the databases are case
insensitive.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Alain" <A***@yahoo.com> wrote in message news:e9fnzIfxFHA.3772@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I was under assumption that case sensitivity in SQL Server will be apply to
> both
> object data as well as identifiers (object names).
> I've istalled the new case sensitivity instance and I'm able to create 02
> databases with same name (in different case), but it does not work for
> tables or SP (it returns "There is already an object named ..." message)
> I'm looking for information that explains where the case sensitive is
> applied and where not
>
> Thank you for your help
>
>