Collation Change

I need to change the collation of a database (Including all the tables,
columns e.t.c) on a SQL Server 2005 SP2. Is there an easy way to do this
other than dropping indexes, creating a script for everything and running it
?
Thanks.DXC
It is not an easy task. In my epxerience you will be better of re-creating
a database from scratch and import all the data.
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:8BBFC84E-6048-4636-A903-8EE7E6EA6FE5@.microsoft.com...
>I need to change the collation of a database (Including all the tables,
> columns e.t.c) on a SQL Server 2005 SP2. Is there an easy way to do this
> other than dropping indexes, creating a script for everything and running
> it ?
>
> Thanks.|||That's what I thought...........Thanks.................
"Uri Dimant" wrote:

> DXC
> It is not an easy task. In my epxerience you will be better of re-creatin
g
> a database from scratch and import all the data.
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:8BBFC84E-6048-4636-A903-8EE7E6EA6FE5@.microsoft.com...
>
>|||I had cause to do this a while back and came across this .Net
application that generates a script to change the collation of all
objects in a database.
http://www.codeproject.com/KB/datab...eCollation.aspx
Be warned, you should backup your database first, take all reasonable
precautions. The databse script can take some time to run on large
databases. I'm not sure that CodeProject waranty the code or the
method in any way.
David.|||Thanks David............This one says "SQL Server 2000 Collation Changer"
.
I don't know if it would work on SQL Server 2005 without any issues but I'll
take a look at it.
"David Halligan" wrote:

> I had cause to do this a while back and came across this .Net
> application that generates a script to change the collation of all
> objects in a database.
> http://www.codeproject.com/KB/datab...eCollation.aspx
> Be warned, you should backup your database first, take all reasonable
> precautions. The databse script can take some time to run on large
> databases. I'm not sure that CodeProject waranty the code or the
> method in any way.
> David.
>