Deanna,

You have to rebuild the master database using the rebuildm utility.
Here is a short into to what it does:

Rebuildm - The Rebuildm utility is used for 1) fixing a corrupt master
database, and 2) changing the character set, sort order or Unicode
collation for a Microsoft SQL Server installation. As usually, make sure
that you have a valid backup(s) for all user databases. After rebuilding
master, you need to reload all your data (user databases) from a
backup(s) you have.


This was taken from Database Journal

http://www.databasejournal.com/features/mssql/article.php/3318461

Look it up in BOL for more details.

Mike


-----Original Message-----
From: Cooper Deanna
[mailto:mssqldba-ezmlmshield-x20966193.[Email address protected]
Sent: Friday, August 31, 2007 4:04 PM
To: LazyDBA Discussion
Subject: Modify Server Collation after SQL Server install

Hi,

I have a Windows 2003 server that has been installed with SQL Server
2000 sp4 using a server collation of SQL_Latin1_General_CP1_CI_AS. I
need to know if I can modify this collation at the server level by
script or using upgrade options after reinserting the SQL Server install
disk?



Regards,

Deanna L. Cooper

Technical Specialist



Tiffany & Company

15 Sylvan Way

Parsippany NJ 07054

973-254-7007





The information contained in this email message may be privileged,
confidential, and protected from disclosure. Any unauthorized use,
printing,
copying, disclosure, dissemination of or reliance upon this
communication by
persons other than the intended recipient may be subject to legal
restriction
or sanction. If you think that you have received this E-mail message in
error,
please reply to the sender and delete this email promptly.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page