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?
> >
> >
> >

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 accordi
ngly.
"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...
> 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.[vbcol=seagreen]
> "Tibor Karaszi" wrote:
sensitivity[vbcol=seagreen]
when I[vbcol=seagreen]

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

Case Insensitivity is on server wide: tables render case sensative...

Hello:

I have created an SQL server table in the past on a server that was all case sensative. Over time I found out that switching to a server that is not case sensative still caused my data to become case sensative. I read an article that said you should rebuild your master database then re-create your tables. So after rebuilding the master database, a basic restore would not be sufficient? I would have to go and manually re-create every single table again?

Any suggestions?Have a look at "Using SQL Collations" in SQL Server Books Online|||Hello:

I went ahead and took a look inside books online and pretty much found things that I already know. My current collation is: SQL_Latin1_General_CP1_CI_AI.. So the server is actually CaSe insensative... But some of my tables still act like case sensitivity is turned on in most areas where I have not done anything on my part to cause this behavior. So I am guessing that since the tables were moved from a CS_AS to a CI_AI, the tables caused were rendered case sensative although it is not in a CS_AS enviornment... My question is that would I need to rebuild the database manually from scratch or is their an easier way to do this? Thank you.|||If the AS collations appear only on a few tables you can alter those tables only - something like:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_819v.asp|||Hello:

Yes I followed that link it was more helpful... looks like a daunting manual task.. thank you