Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
FretTapper
Starting Member
2 Posts |
 Posted - 2001-03-21 : 12:38:04
|
| I am inserting a single row, I want to trigger off that INSERT in such a way that the INSERT returns as soon as the INSERT has completed rather than waiting for the trigger to complete as well. I have tried AFTER INSERT in the trigger and it doesn't do the trick. Basically I'm asking if anyone knows a slick way of accomplishing something in the background in a trigger-like way without hanging my app. while it completes.FYI The row insert is basically instantaneous whereas the event i want triggered can take as much as 40 seconds. |
|
|
|
|
|
I need to run a background proc on a trigger