title: create script to change the collation of a database
body: <p>I have been working with a sql server 2012 database for a number of weeks and now I would like to change the collation of the database.</p>
  
  <p>I thought it would be easy to just change its overall setting but unfortunately this is only applied to that point forth and not the current setup of database. </p>
  
  <p>So I need to generate a script to change the collation of the database, including its existing content/structure.</p>
  
  <p>Anyone can assist with automating this or any tips how might generate a script to achieve this?</p>