How can i chang server level collation

Dear All,
How can i change my SQL server level collation.
Thank's in advance.
Faheem Latif
Network Solutions PVT LTM.
Pakistan.You can rebuild the master database. There is a bug with this if you use
sourcefiles off the cd, so have a look at these articles:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_8w8p.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;273572
Be very careful with this, as you'll need to have scripts of logins, linked
servers, messages and anything else you have in master and corresponding
scripts of MSDB's objects, all of which can then be recreated afterwards.
Actually you might not need to jump through all these hoops - why is it that
you want to change the collation?
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

How can i chang server level collation

Dear All,
How can i change my SQL server level collation.
Thank's in advance.
Faheem Latif
Network Solutions PVT LTM.
Pakistan.
You can rebuild the master database. There is a bug with this if you use
sourcefiles off the cd, so have a look at these articles:
http://msdn.microsoft.com/library/de...stall_8w8p.asp
http://support.microsoft.com/default...b;en-us;273572
Be very careful with this, as you'll need to have scripts of logins, linked
servers, messages and anything else you have in master and corresponding
scripts of MSDB's objects, all of which can then be recreated afterwards.
Actually you might not need to jump through all these hoops - why is it that
you want to change the collation?
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)