I'm trying to change the collation type of the master database to
SQL_Latin1_General_CP1_CI_AS using RebuildM.exe . I don't see this collation
in the drop down list box. I'm using SQL Server 2000 SP2.

Is there a way I can select the collation I require from rebuildm.exe?

--
Regards

Nick T

Nick T (NickT (AT) discussions (DOT) microsoft.com) writes:
First make sure that you check the radio button which reads "SQL Collations"
on the bottom half of the screen. In the list box, select "Dictionary order,
case-insensitive, for use with 1252 Character set".

Next, download and install SP4 of SQL 2000. If you only have SP2 you are
a potential victim of the slammer worm.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx