William
Thu Sep 09 12:45:46 CDT 2004
It should.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Bragadiru" <adi_lazar@hotmail.com> wrote in message
news:OnIjirjlEHA.896@TK2MSFTNGP12.phx.gbl...
> Thnx.
>
> But database case-insensitive setting doesn't ovveride server instance
> collation setting ?
>
> Thanks a lot.
>
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> news:OoEp%23sdlEHA.396@tk2msftngp13.phx.gbl...
>> Yup. That's by design. When you choose case-sensitivity ALL objects are
> also
>> considered in the string comparisons.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> __________________________________
>>
>> "Bragadiru" <adi_lazar@hotmail.com> wrote in message
>> news:OJsZT1YlEHA.948@TK2MSFTNGP12.phx.gbl...
>> > Hi all,
>> >
>> > I installed a Ms SQL Server 2000 instance with a case-sensitive
> collation,
>> > but I have databases with case-insensitive collations. When I try to
> make
>> > a
>> > ExecuteQuery through ADO.NET on case-insensitive database tables I need
> to
>> > set the CommandText in a case-sensitive manner, otherwise I get error
>> > messages : I have a table named MyTable, if CommandText is "SELECT *
> FROM
>> > myTable" => error message : object 'myTable' does not exist and "SELECT
> *
>> > FROM MyTable" works fine.
>> > 1. This is the correct behaviour ? Any workaround ? It's hell to
> remember
>> > exactly the column or table names
>> > 2. How can I find the sql server collation ? (programatically)
>> >
>> > I'm using .NET Frmw 1.0
>> >
>> > Thanks
>> >
>> >
>>
>>
>
>