Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.