All Questions
3 questions
0
votes
1
answer
568
views
how to convert from raiserror to throw in the current context?
I have a function that checks is the file is present on disk in an specific location.
Using that function I am checking for the latest backup, in the code below.
If we don't have a backup anymore, ...
- 16.6k
0
votes
1
answer
563
views
How can I RAISE_APPLICATION_ERROR and do an INSERT in the same trigger?
From what I see, having the RAISE_APPLICATION_ERROR cancels the other operations that I would have in the trigger. I tried writing first the INSERT and then the RAISE_APPLICATION_ERROR hoping that ...
- 115
2
votes
1
answer
3k
views
Is it possible to raiserror within a For Delete Trigger that rolls back the deletes
There is a claim at the end of this accepted answer that if an error occurs within a "For Delete" trigger, the delete action would be rolled back because it is part of an implicit transaction.
...
- 2,130