Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

see also How do I change the system wide collation setting in SQL Server 2005

Is there an easier way to change the system wide (temp db) collation setting in SQL Server 2008 other then a full restore?

If I do a full reinstall is there a quicker way of keeping my database other then doing a backup/restore.

(As this is a development PC, database downtime while this is being done is not an issue)

share|improve this question
detaching from the old instance and attaching to the new would be quicker. Make sure your new instance is same SP level as the old. – SqlACID May 26 '11 at 10:58

Not that I know of. If you think about what has to happen it makes sense; the RDBMS has save the text data to disk with a set of codes to represent the individual characters in each piece of text. Now you are asking to potentially change the encoding of each character, which of course means looking at each one and possibly changing it. And it may have to allocate more or less space for each character depending on the from/to collation.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.