title: SQL Update Trigger Error-(Cannot create trigger because table has foreign key with a update cascade)
body: <p>I am using <code>SQL</code> server 2008 and I have <code>payment</code> table and <code>paymentLog</code> table.  </p>
  
  <pre><code>Create Table Tab_Payment
  (
      Eid integer NOT NULL, 
      Date_of_Reflect date NOT NULL, 
      Amount integer NOT NULL,
      ...
      Constraint PK_Payment Primary Key(Eid,Date_of_Reflect),
      Constraint FK_Emp Foreign key (Eid) references Tab_Employee(Eid) ON DELETE NO ACTION ON UPDATE CASCADE,
  );
  </code></pre>
  
  <p>I am going to used a trigger to insert data to paymentLog.  </p>
  
  <pre><code>Create Trigger Trigger_Payment_Audit
  on Tab_Payment
  after  update
  As
      ...
  GO
  </code></pre>
  
  <p>I cannot create the trigger. Below error comes. What should I do to fix this.<br>
  <strong>Cannot create INSTEAD OF UPDATE trigger 'Trigger_Payment_Audit' on 'Tab_Payment'. This is because table has a FOREIGN KEY with cascading UPDATE.</strong>  </p>
  
  <p>I have found similar post on SO. Bout that did't helped me.  </p>