changing collation_name of SqlServer Database

Hi

I want to change collation_name of my SqlServer Database by running a script. But I don't know how.
Please help me.

ThanksYou should be able to do this:

ALTER DATABASE myDatabase COLLATE SQL_Latin1_General_CP1_CI_AS

This will change the default collation for any new objects added to the database. To change the collation of existing objects you will need to run an ALTER TABLE command against each table.

Terrisql