Besides, when the SP invokes "raiserror", the error code given as a parameter to "raiseerror" is returned from the SP.

If no error occurs, then it returns 0.

So, i don't really...

This solution may work, but :

a) I have another constraints that i have to satisfy (i have nested transactions as well, so i really need the rethrow exception mechanism...)

b) I'm...

The T-SQL code i posted in the original post was an attempt to simplify the problem, the actual code looks more like this :

CREATE PROCEDURE dbo.IntSP(@ret varchar(100) output)

AS

BEGIN

...

Im trying to do so, checked and double checked everything...