title: Sql Azure , Truncate and Reseed All Tables
body: <p><code>DBCC</code> is not available in <code>Sql Azure</code> so basically we cant perform <code>DBCC</code> actions. So how we do the reset for identity in <code>Sql Azure</code>.</p>
  
  <p>i written this to Truncate all records and Reseed the Tables to 1 and obviously this is not going to work cause <code>DBCC</code> is not Allowed.</p>
  
  <pre><code>EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’
  EXEC sp_MSForEachTable ‘DELETE FROM ?’
  EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’
  DBCC checkident (?, RESEED, 1)  ??
  GO
  </code></pre>
  
  <p>So how i do the Reseed with this script.</p>