title: Unable to Change Database Default Collate
body: <p>I cannot alter database tempdb because it is a system database.</p>
  
  <p>I installed a fresh SQL Server 2008 R2 on my system, by default it got the collation as <code>Latin1_General_C1_Ai_WS</code>. But my Database Collation is <code>SQL_Latin1_General_C1_Ai_AS</code>.</p>
  
  <p>So, I am getting Collation Error in all the places whereever I have used temp tables.</p>
  
  <p>All temp (#) tables are getting created with the default collate <code>Latin1_General_C1_Ai_WS</code>, so wherever I have used temp table, I am getting an error.</p>
  
  <p>I tried reconfiguring but it didn't work.</p>
  
  <p>Because of this I am manually adding collate in all temp tables. </p>
  
  <p>Please Help.... Thank You!</p>