> What do you mean? I use commit and rollback with stored procs all

the time

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.

Regards.