Case Sensitive Flag

I have a customer with MS-SQL7 they have to have the case sensitive flag on for a database they purchased some time ago. Can I attach a database to the same SQL server and some how remove the case sensitive flag for just this DB?Not possible - this is set at the server level and affects all databases.
"Dan C" <anonymous@.discussions.microsoft.com> wrote in message
news:8D10190E-A01E-4950-B2AE-F62BCBD2C6A9@.microsoft.com...
> I have a customer with MS-SQL7 they have to have the case sensitive flag
on for a database they purchased some time ago. Can I attach a database to
the same SQL server and some how remove the case sensitive flag for just
this DB?|||Hi Dan,
You (or your customer) is out of luck there. The collation (which includes
among other things the setting for case sensitivity) is a server wide
setting on SQL Server 7. You either need a separate server for that
database, or you need to upgrade to SQL Server 2000, or you can install a
named instance of SQL Server 2000 (with the appropriate collation) on the
same machine as SQL Server 7 is running on.
--
Jacco Schalkwijk
SQL Server MVP
"Dan C" <anonymous@.discussions.microsoft.com> wrote in message
news:8D10190E-A01E-4950-B2AE-F62BCBD2C6A9@.microsoft.com...
> I have a customer with MS-SQL7 they have to have the case sensitive flag
on for a database they purchased some time ago. Can I attach a database to
the same SQL server and some how remove the case sensitive flag for just
this DB?sql