Fraggle-805517 (4/19/2013)
Hello everyone. Hope you are all having a great Friday.....
....BEGIN CATCH
<< LOG Conversation and Task Message to error table >>
END CONVERSATION @Conversation_handle
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRAN
END
END CATCH
Looks like a bad logic, look at CATCH block, first you have a END CONVERSATION statement and then ROLLBACK which rollback also the END CONVERSATION statement. And the same is true for << LOG Conversation and Task Message to error table >>