title: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation
body: <p>I am getting below said collation error since I have moved from a desktop machine to a laptop. My database has hundreds of stored procedures, so any solution like overriding some queries or fix collation for a column is not possible for me. </p>
  
  <p>"Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation"</p>
  
  <p>My problem is not unique and I have searched for this quite a lot, but solutions available suggest me to override queries with some code which is not feasible. Please suggest some solution that may avoid this collation thing. </p>
  
  <p>I have tried this to alter my database collation.</p>
  
  <pre><code>ALTER DATABASE testDB  
  COLLATE French_CI_AI ;  
  GO  
  </code></pre>
  
  <p>Thanks.</p>