Changing SQL Server 2008/2008 R2 Collation

The server collation acts as the default collation for all system databases that are installed with the instance of SQL Server including newly created user databases. Changing the default SQL Server collation can be a complex operation so if you can please avoid must especially those with large user databases. Follow the steps below to change the SQL Server collation for newly installed SQL rather than having to re-install SQL all over again.