You can set it at the database level, do you really need it at the
server level?

-----Original Message-----
From: Cooper Deanna
[mailto:mssqldba-ezmlmshield-x20966193.[Email address protected]
Sent: Friday, August 31, 2007 1: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