Hello All:
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
(Begin/Write/Flush).
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:
BEGIN TRY
BEGIN TRAN
<EXEC the 3 procs>
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK TRAN
SELECT GETDATE()
END CATCH
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!
--
Todd C
>> Stay informed about: Failing NSEvent Begin Batch procs