Can I change the SQL 2000 Cluster database from case-sensitive to case-insensitive in the

Hi All,
I'd like to know if I can change the SQL 2000 Cluster database configuration
from case-sensitive to case-insensitive in the running box. If yes, how can
I do that?
TIACould you please send more detail and/or one example of what you are trying
to accomplish?
Ben Nevarez, MCDBA, OCP
Database Administrator
"M C" wrote:
> Hi All,
> I'd like to know if I can change the SQL 2000 Cluster database configuration
> from case-sensitive to case-insensitive in the running box. If yes, how can
> I do that?
> TIA
>
>|||Hi ALL,
When I first installed SQL 2000 Cluster, I choose the case-sensitive when
the setup prompt for collation. I'm now want to change the collation to
case-insensitive. Can I do that?
TIA.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:404BF5E3-E8E0-420A-9193-6E41C93B2DE3@.microsoft.com...
> Could you please send more detail and/or one example of what you are
> trying
> to accomplish?
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "M C" wrote:
>> Hi All,
>> I'd like to know if I can change the SQL 2000 Cluster database
>> configuration
>> from case-sensitive to case-insensitive in the running box. If yes, how
>> can
>> I do that?
>> TIA
>>|||"M C" <abc@.def.com> wrote in message
news:umNMiyomGHA.3732@.TK2MSFTNGP05.phx.gbl...
> Hi ALL,
> When I first installed SQL 2000 Cluster, I choose the case-sensitive when
> the setup prompt for collation. I'm now want to change the collation to
> case-insensitive. Can I do that?
Not on a server-wide basis w/o doing a complete re-install.
On a per database basis you can, but it can get messy.
> TIA.
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:404BF5E3-E8E0-420A-9193-6E41C93B2DE3@.microsoft.com...
> >
> > Could you please send more detail and/or one example of what you are
> > trying
> > to accomplish?
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "M C" wrote:
> >
> >> Hi All,
> >>
> >> I'd like to know if I can change the SQL 2000 Cluster database
> >> configuration
> >> from case-sensitive to case-insensitive in the running box. If yes, how
> >> can
> >> I do that?
> >>
> >> TIA
> >>
> >>
> >>
>sql