Change collation on entire database

Hello there
I need to change on the entire database all the collations to one collation.
The only way I now it is possible is by:
ALTER TABLE TableName
ALTER COLUMN ColumnName
ColType(ColSize)
and other properties
EXEPT COLLATE newCollateName
That way is very dangures because i must know all the rest properties of the
fields.
Is there a way to change only the collation?To change this, I will use a query that I Adapted from Justin Mallier''s
blog:
(http://mallier.blogspot.com/2005/11.../drsql/blog/cns!80677FB08B3162E4!842.entry
--
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23tbCR3tOGHA.3732@.TK2MSFTNGP10.phx.gbl...
> Hello there
> I need to change on the entire database all the collations to one
> collation.
> The only way I now it is possible is by:
> ALTER TABLE TableName
> ALTER COLUMN ColumnName
> ColType(ColSize)
> and other properties
> EXEPT COLLATE newCollateName
> That way is very dangures because i must know all the rest properties of
> the fields.
> Is there a way to change only the collation?
>