Pages

Thursday 22 May 2008

Changing collation of tempdb database

If you only want to change the collation of the tempdb without rebuilding the master, you can do that by restoring a copy of the model database that has the correct collation then restarting the sql server service.
Every time the sql server service is restarted, it rebuilds the tempdb from the model.