yo tengo mis procesos con este schema:
Código SQL:
Ver originalALTER PROCEDURE
AS
BEGIN
SET NOCOUNT ON
BEGIN try
END try
BEGIN catch
INSERT INTO TABLE
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() AS ErrorState,
ERROR_PROCEDURE() AS ErrorProcedure,
ERROR_LINE() AS ErrorLine,
ERROR_MESSAGE() AS ErrorMessage;
END catch
END
y no uso transacciones :)