CREATE PROCEDURE dbo.spname
AS
BEGIN
BEGIN TRANSACTION;
BEGIN TRY
/*
YOUR COMMAND
/*
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION;
END CATCH;
IF @@TRANCOUNT > 0
COMMIT TRANSACTION;
END;
Cheers!
Uma
Cheers!
Uma