469,362 Members | 2,294 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,362 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 1605

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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.