title: Sql Server 2008 : Cannot define foreign key constraint with cascaded DELETE or UPDATE
body: <p>When trying to apply the <code>ON CASCADE UPDATE</code> or <code>ON CASCADE DELETE</code> for some foreign key, I get the following error : </p>
  
  <blockquote>
    <p>Msg 1787 : Cannot define foreign key constraint  with cascaded DELETE or
    UPDATE on table because the table has an INSTEAD OF DELETE or
    UPDATE TRIGGER defined on it.  </p>
  </blockquote>
  
  <p>here is my SQL code : </p>
  
  <pre><code>ALTER TABLE myTable ADD CONSTRAINT [FK_ACTE__CODE_OBJET_ACTE] FOREIGN KEY ([My_Column] ) REFERENCES Table_Referenced ([Column_Referenced]) ON UPDATE CASCADE  ON DELETE CASCADE ;  
  </code></pre>
  
  <p>What is the problem with my request ? Is CASCADE condition incompatible with instead of delete or update triggers ?</p>