Case Sensative Coallation

I have a case-sensative database which I want to attach to an insensative in
stance 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 datab
ase 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 hopi
ng that I could attach a case sensative database to an instance of SQL serve
r which was originally installed with Collation Settings insensative, and ha
ve the database act accordi
ngly.
"Tibor Karaszi" wrote:

> I assume that you mean that you want to attach a SQL Server *database*, no
t an *instance*. Case sensitivity
> follows with the database. Can you point to how you determine that the dat
abase 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...
> 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 col
lation 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 tha
t I could attach a case
sensative database to an instance of SQL server which was originally install
ed with Collation Settings
insensative, and have the database act accordingly.[vbcol=seagreen]
> "Tibor Karaszi" wrote:
>
sensitivity[vbcol=seagreen]
when I[vbcol=seagreen]sql