Friday, August 10, 2012

Change collation for tempdb

You can change collation for any user database with the following query: 

ALTER DATABASE database_name COLLATE collation_name

But changing collation of TempDB is little bit different. In this case 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.

No comments:

Post a Comment