You can change collation for a database and a column. But if you would like to set your new collation as default, you have to rebuild master database.