title: Risk and effects of changing database collation in SQL Server
body: <p>Since my SQL Server 2012 instance is using a collation (<code>Latin1_General_CI_AS</code>) different to some DBs in use (<code>SQL_Latin1_General_CP1_CI_AI</code>), I was evaluating possible risks of changing the collation of the databases using a different collation than the SQL Server instance.</p>
  
  <p>I retrieved hundreds of procedure to perform this step. What is not clear for me is to understand if there are some constraints or risk on performing an action such this.</p>
  
  <p>Thanks for any replies.</p>