SQL Collations - change an existing collation 1

[DLTaylor]

Currently i have database (I will call: testdb) with the collation:
SQL_Latin1_General_CP1_CS_AS
My masterdb collation is:
SQL_Latin1_General_CP1_CI_AS

i.e. masterdb is case insensitive and testdb is case sensitive.

I now need to convert the masterdb collation to match the LiveDB collation - is there an easy way to do this and are there any potential pit falls?

Any help will be much appreciated
Thanks
Dan

 

[hmckillop]

have a look at this, it should do the job for you.

http://www.leyton.org/techiemusings/2004/08/12/sql-server-and-collation-settings

"I'm living so far beyond my income that we may almost be said to be living apart