title: What should be the query for setting foreign key to zero in sql server r2?
body: <p>I am using </p>
  
  <p><code>SET FOREIGN_KEY_CHECKS=0;</code> </p>
  
  <p>for My sql but i need the same query in Sql Server, I tried this </p>
  
  <p><code>ALTER TABLE MyTable NOCHECK CONSTRAINT ALL;</code></p>
  
  <p>but its not working for me somehow. Can anybody tell me how to write</p>
  
  <p><code>SET FOREIGN_KEY_CHECKS=1;</code> </p>
  
  <p>same query in sql server?</p>