469,284 Members | 2,508 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,284 developers. It's quick & easy.

Changing collation for tempdb and model

Hi,
I've got a production server with the default collation
and User DBs with the different collation.
Now when I create temporary tables and compare with the permanent ones
we have collation problems. Is it possible to change tempdb ( and
model) collations ?
Would I need to change master and msdb collations as well?
Can I change the master collation? What about all the tables that
already exist in these system databases?
Is it fairly straight forward to change collation for tempdb and model
or it might cause problems in the future - I obvioulsy don't want to
mess up with the production server

Thanks a lot

Jul 23 '05 #1
0 1603

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Rolando | last post: by
reply views Thread by polinaskulski | last post: by
1 post views Thread by polinaskulski | last post: by
1 post views Thread by John Jayaseelan | last post: by
8 posts views Thread by arijitchatterjee123 | last post: by
5 posts views Thread by Sai | last post: by
9 posts views Thread by gopi | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.