Bad news and good news.

Bad News - You cannot change collation settings on the fly for the server ....

What you need to do is rebuild your system databases if you...