Chaging the recovery and page verify options of master can be done using the standard ALTER DATABASE command.
Changing the server collation (master database) requires you to rebuild the master database. This is a little more difficult, as it requires you to detach user databases, run the setup.exe and re-attach the user databases.
Read BOL to find out - however, that document says to drop the user databases, don't do that!! Detaching and re-attaching them should be sufficient.
answered Sep 23, 2011 at 12:00 AM