Good morning! In moving a database from one server to a cluster I was hoping to change the case sensitivity from case sensitive to non sensitive. Could some assist me in the correct SQL tatement I would need to accomplish that? Thanks again.
You cannot change the collation of a database. You can move the database
objects to a database with a different collation by using DTS.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Hi
There are quite a few posts regarding this on Google...for example:
http://tinyurl.com/27a82
John
"robert salazar" <rsalazar@.cbbank.com> wrote in message
news:44A44164-8868-4CA5-9B0F-82592ABCDA43@.microsoft.com...
> Good morning! In moving a database from one server to a cluster I was
hoping to change the case sensitivity from case sensitive to non sensitive.
Could some assist me in the correct SQL tatement I would need to accomplish
that? Thanks again.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment