-
How to wait of trigger execution
Hi,
i want to run 3 procs in one main stored procedure, but between each execution there is a trigger. The trigger take a while.
I would like that the next procs wait the end of the trigger?
Example:
Main procedure
exec proc1; (at the end of proc1 a trigger1 starts)
exec proc2; (at the beginnen of proc2, it must wait of the exec of trigger1. at the end trigger2 starts)
exec proc3; ....
Thank's
-
what sort of trigger are you talking about?
-
After update trigger.
This trigger runs others stored procedures.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|