Thanks,

I was afraid so. Is it possible to backup master db, run rebuildm to change
its collation and then restore it (and MSDB I guess, because it also gets
rebuilt, right?) back so that I don't have to reattach?

Mordechai

-----Original Message-----
From: Davis Ralph
[mailto:mssqldba-ezmlmshield-x60049643.[Email address protected]
Sent: Tuesday, January 30, 2007 12:15 PM
To: LazyDBA Discussion
Subject: RE: changing tempdb collation

I believe the server collation must change for any system databases to
change, and they all will be the same(master, msdb, tempdb, etc.)

Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************
-----Original Message-----
From: Mordechai Danielov
[mailto:mssqldba-ezmlmshield-x71819851.[Email address protected]
Sent: Tuesday, January 30, 2007 10:57 AM
To: LazyDBA Discussion
Subject: changing tempdb collation

Is there a a way to change tempdb collation, or do I have to change the
server collation for that?



---------------------------------------------------------------------
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
****************************************************************
Confidentiality Note: The information contained in this
message, and any attachments, may contain confidential
and/or privileged material. It is intended solely for the
person(s) or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in
reliance upon this information by persons or entities other
than the intended recipient(s) is prohibited. If you received
this in error, please contact the sender and delete the
material from any computer.
****************************************************************


---------------------------------------------------------------------
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