DON'T KNOW. Every time I have tried a rebuild it was as if you
reinstalled SQL and started over.

Why are you doing this? There is a reason the master, msdn, and tempdb
are the same collation. If tempdb was different you would begin getting
collation conflicts on all comparisons using temptables etc. I've seen
this when loading a database of a different collation on a server.
Unless maybe you were using completely Unicode and then it would not
matter what collation tempdb was.

Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************

-----Original Message-----
From: Mordechai Danielov
[mailto:mssqldba-ezmlmshield-x81271848.[Email address protected]
Sent: Tuesday, January 30, 2007 11:34 AM
To: LazyDBA Discussion
Subject: RE: changing tempdb collation

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



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

MS Sql Server LazyDBA home page