Daanish G

Daanish G

  • NA
  • 42
  • 7.5k

What is the reason for this error?

Jul 25 2022 9:07 AM

What is the reason for this error?

Msg 2113, Level 16, State 1, Procedure DISTRACTPERMIT, Line 1 [Batch Start Line 4]
Cannot create INSTEAD OF DELETE or INSTEAD OF UPDATE TRIGGER 'DISTRACTPERMIT' on table 'dbo.USER_PEMITION'. This is  because the table has a FOREIGN KEY with cascading DELETE or UPDATE.


Answers (2)