Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to change collation for master database

Author  Topic 

askcomputer
Starting Member

12 Posts

Posted - 2006-08-07 : 18:47:22
Hi

I have one database server(SQL Server 2000 version). this sever's master dabase collation set as a latin1_General_BIN, I want change collation to SQL_Latin1_General_CP1_CI_AS collation.

How to change collation latin1_General_BIN to SQL_Latin1_General_CP1_CI_AS collation for master database.

Regards
Santosh

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-07 : 19:35:44
look up the rebuildm utility in Books Online.


-ec
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-08-07 : 22:07:07
My advice is to reinstall SQL Server.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Collate,Collation

Kristen
Go to Top of Page
   

- Advertisement -