I have been of the understanding that a Stored Procedure is contained in one Transaction when SQLServer is in autocommit mode. Lately I have wondered if I might be way of here.

Can anyone shed some light on this for me?

Thanks.

Gert

When SQL Server is in autocommit mode, which is the default when no explicit transaction has been created or specified, then each SQL statement is separately comitted or rolled back when it completes. If the statement completed successfully, it is committed; if it encounters any error, it is rolled back.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com