It seems to me that SQL THROW is missing a crucial feature that
RAISERROR
has, and that is the abilty to use WITH LOG
so that an Alert can be fired when the error number is logged in the Application log.
Is there a simple way to do this that is escaping me or do I still have to rely on the more cumbersome RAISERROR
and sp_addmessage
SP?
I would like to be able to notify an Operator through an Alert using THROW
in a CATCH
block.
Asked by Christian McGhee
(23 rep)
Sep 26, 2014, 04:45 PM
Last activity: Jul 20, 2022, 03:39 PM
Last activity: Jul 20, 2022, 03:39 PM