something like this should work...

declare

@ErrorMessage NVARCHAR(4000),

@ErrorNumber INT,

@ErrorSeverity INT,

@ErrorState INT,

@ErrorLine INT,

@ErrorProcedure NVARCHAR(200)

begin try

begin Tran

.....

commit tran

end try

begin catch

begin try

ROLLBACK TRANSACTION

end try

begin catch

end catch

SELECT

@ErrorNumber = ERROR_NUMBER(),

@ErrorSeverity = ERROR_SEVERITY(),

@ErrorState = ERROR_STATE(),

@ErrorLine = ERROR_LINE(),

@ErrorProcedure = ISNULL(ERROR_PROCEDURE(), '-');

SELECT @ErrorMessage =

N'Error %d, Level %d, State %d, Procedure %s, Line %d, ' +

'Message: '+ ERROR_MESSAGE();

RAISERROR

(

@ErrorMessage,

16,

1,

@ErrorNumber, -- parameter: original error number.

@ErrorSeverity, -- parameter: original error severity.

@ErrorState, -- parameter: original error state.

@ErrorProcedure, -- parameter: original error procedure name.

@ErrorLine -- parameter: original error line number.

);

end catch