How to change the DataBase Collation!

Hello all:
I try to change the Collation of database, but it not work in
vb.net 2005, have any one do it before?
MatchSQL,
Use "alter database", but this does not change the collation for all char /
nchar / varchar / nvarchar / etc. columns.
How to transfer a database from one collation to another collation in SQL
Server
[url]http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server& cat=en_US_671e06d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US[/url]
AMB
"MatchSQL" wrote:

> Hello all:
> I try to change the Collation of database, but it not work in
> vb.net 2005, have any one do it before?
>