How to change collation on a server?

I use SQL server 2000.
How to change collation on a server?. When I execute "rebuildm.exe" to
change collation on a server, computer always be Hung. Why is it happended?
How to solve it?Hi
Use ALTER DATABASE ... command. Actually the old objects will remain with
old COLLATION.
To change it take a looka ALTER TABLE....ALTER COLUMN ... commands
For more details please refer to the BOL.
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:%23xfHor5VGHA.5076@.TK2MSFTNGP11.phx.gbl...
>I use SQL server 2000.
> How to change collation on a server?. When I execute "rebuildm.exe" to
> change collation on a server, computer always be Hung. Why is it
> happended?
> How to solve it?
>|||Copy the source files for the system database to the hard drive, and *remove
the read-only
attribute* of those files. Then point to that location when you run rebuildm
.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:%23xfHor5VGHA.5076@.TK2MSFTNGP11.phx.gbl...
>I use SQL server 2000.
> How to change collation on a server?. When I execute "rebuildm.exe" to
> change collation on a server, computer always be Hung. Why is it happended
?
> How to solve it?
>