Catching an error from a trigger to a sp

• mnorton

  SSC Veteran

  Points: 228

  More actions

  December 12, 2003 at 2:05 pm

  #81701

  Does anyone know how to catch an error from a trigger when it's rolling back to a stored procedure? Right now we have a stored procedure that keeps looping through because we can't seem to catch the error from the trigger. Can this be done? Need help. Stored procedure is too long to post to the forum. Any help would be greatly appreciated. TIA,

  Melanie

  PS. How do we catch the raiserror from the trigger?

  See sample code of what we are trying to do: Not actual code (too long to post)

  ALTER Proc TestTrig As

  Begin Tran

  --Select 'Begin Tran'

  Update Titles

  Set type = 'UndeCided'

  Where Type = 'UNDECIDED'

  commit

  --Print 'commit'

  Select @@rowcount

  Select distinct type From Titles

  ---------------------------------------------------------------------------

  ALTER TRIGGER reminder

  ON titles

  FOR INSERT, UPDATE

  AS

  RAISERROR (50009, 16, 10)

  Rollback

  return

  Select * from Master..sysmessages

• jxflagg

  Hall of Fame

  Points: 3817

  More actions

  December 12, 2003 at 2:25 pm

  #486035

  You should be able to check the value of @@error from your stored procedure right after the insert or update statement