CREATE PROCEDURE [dbo].[nameProcedure]
(campos)
AS
BEGIN
BEGIN TRY
BEGIN TRANSACTION
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0 BEGIN
ROLLBACK TRANSACTION
END
SELECT CONCAT('Msg Error: ',ERROR_MESSAGE(), '- Procedimiento
Afectado:', ERROR_PROCEDURE(), ' - Linea Afectada', ERROR_LINE())
END CATCH
END