Help SQL Server 2000

When I have done to attach database at server with certain collation. So how
to change its collation like as i want?
Because I've tried to use "ALTER DATABASE ... COLLATE ...", But it doesn't
change all tables.
How to to change its collation like as i want so simple?When you say all tables, do you mean some columns. It may be more effective
to set up the db, with required collation and the migrate data
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:#D5vF2XXGHA.3328@.TK2MSFTNGP02.phx.gbl...
> When I have done to attach database at server with certain collation. So
how
> to change its collation like as i want?
> Because I've tried to use "ALTER DATABASE ... COLLATE ...", But it
doesn't
> change all tables.
> How to to change its collation like as i want so simple?
>