Just caught the question in the recent post. If I can remember my own code correctly:-) The reason the delete of the table variable must happen after the transaction commits is that the table variable data is used in the Catch clause if the transaction fails and rolls back. Therefore it is deleted only after the transaction commits.