Case Sensative Coallation

I have a case-sensative database which I want to attach to an insensative instance of SQL Server, but when I attach, it remains case sensative. How can I change it to insensative?I assume that you mean that you want to attach a SQL Server *database*, not an *instance*. Case sensitivity
follows with the database. Can you point to how you determine that the database changes case sensitivity?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JDArsenault" <JDArsenault@.discussions.microsoft.com> wrote in message
news:FEA9C167-4E33-4E73-88F0-6BD32287C578@.microsoft.com...
> I have a case-sensative database which I want to attach to an insensative instance of SQL Server, but when I
attach, it remains case sensative. How can I change it to insensative?|||The database doesn't change sensativity. Sorry for any confusion. I was hoping that I could attach a case sensative database to an instance of SQL server which was originally installed with Collation Settings insensative, and have the database act accordingly.
"Tibor Karaszi" wrote:
> I assume that you mean that you want to attach a SQL Server *database*, not an *instance*. Case sensitivity
> follows with the database. Can you point to how you determine that the database changes case sensitivity?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "JDArsenault" <JDArsenault@.discussions.microsoft.com> wrote in message
> news:FEA9C167-4E33-4E73-88F0-6BD32287C578@.microsoft.com...
> > I have a case-sensative database which I want to attach to an insensative instance of SQL Server, but when I
> attach, it remains case sensative. How can I change it to insensative?
>
>|||I see. Sorry to say that, but collation goes with the database. Changing collation is not an easy task, search
the archives for more info. If you don't find info there, you can post again...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JDArsenault" <JDArsenault@.discussions.microsoft.com> wrote in message
news:55CCFB46-5F43-46A0-B53D-CE7C443AA30C@.microsoft.com...
> The database doesn't change sensativity. Sorry for any confusion. I was hoping that I could attach a case
sensative database to an instance of SQL server which was originally installed with Collation Settings
insensative, and have the database act accordingly.
> "Tibor Karaszi" wrote:
> > I assume that you mean that you want to attach a SQL Server *database*, not an *instance*. Case
sensitivity
> > follows with the database. Can you point to how you determine that the database changes case sensitivity?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "JDArsenault" <JDArsenault@.discussions.microsoft.com> wrote in message
> > news:FEA9C167-4E33-4E73-88F0-6BD32287C578@.microsoft.com...
> > > I have a case-sensative database which I want to attach to an insensative instance of SQL Server, but
when I
> > attach, it remains case sensative. How can I change it to insensative?
> >
> >
> >