This happens a lot of times that you install your Sql Server with a particular collation and find that the database you need to have on the server requires a different collation. At first this seems to be pretty simple. I thought I would just go to the Server properties and change it. I made a confident move for it only to find that the collation cannot be edited from the properties. I browsed through a few online forums which suggested re-installing the Sql Server. I was not willing to give re-installation a try (Installing the MS Sql Server really makes you develop ardent love for cloud services). So I asked a few peers around and then eventually the IT guys and all of them suggested a re-installation. Re-installing the Sql Server is a cumbersome task. Also the collation property box (though inactive) would not let me think that there was not a simpler way to do it. After a little searching I finally found a simpler way.
