Failing NSEvent Begin Batch procs
I have a somple NS app with an Event Class. I am submitting events as follows:
The source Db has a trigger that gets fired ON INSERT
The trigger call a Stored Procedure in the same Database.
The SP then calls the 3 procedures in NS to submit the event
All that works fine, but I want the users of the source Db to be able to
insert records into their table even if the NS procs fail.
In the middle proc, I have the following:
<EXEC the 3 procs>
Now, even if the NS database is off line, I can still execute the above proc
by itself and it executes fine ("Command executed sucessfully.") But when it
gets call from the trigger, it does not go through, the trigger fails, and
the INSERT does not happen.
How can I get this middle proc to SUCCEED even if NS is unavailable?
(WITHOUT having to resort to a Service Broker app!)
Thanks in advance!
|<Prev in Thread]
||[Next in Thread>|
- Failing NSEvent Begin Batch procs,
Todd C <=