Skip to content

How to change collation for tempdb?

Changing database collation for tempdb is little different than changing collation for any other system or user database. Here, you cannot change tempdb collation with ALTER DATABASE command.
Instead, you have to change the collation of model database to the required collation setting that you want for tempdb. After that restart SQL Server services and you will find that tempdb collation has changed.
Note:- Remember whenever SQL Server services are restarted, tempdb is recreated using model database and it will inherit all the properties of model database.

One Comment Post a comment
  1. Yuliya #

    How can I change the collation of the model database then? When I try to use ALTER DATABASE model COLLATE , SQL Server throws exception:
    Cannot alter the database ‘model’ because it is a system database.

    April 19, 2013

Leave a Reply

You may use basic HTML in your comments. Your email address will not be published.

Subscribe to this comment feed via RSS