>>Please note the word INSIDE in my post. SQL Server allow you to do a

commit INSIDE a stored procedure. In your example you are using it
OUTSIDE the stored procedure.

What we are talking about is something like this:

create procedure somename as
begin
insert into sometable (<somefields>) values (<somevalues>);
commit;
end>>

> I could live without beer and filet mignon and chocolate, too, but I

prefer

> not to.

As you can see, you actually live without it.
You just didn't know.

I agree, then: I don't see any value to that feature (the ability to call
commit from WITHIN a stored proc's code). I want to have programmatic
control of whether the stored proc commits or not, based on whether any
errors were encountered.

I don't miss having no lima beans in my fridge.

Clay Shannon,
Dimension 4 Software