2
Answers

What is the reason for this error?

Photo of Daanish G

Daanish G

2y
521
1

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)