Just wondering can my app start a transaction with Begin Transaction and
then call a stored procedure that contains the SUSPEND sentence at the end
while the transaction is still opened? Is there any special consideration
when comencing a transaction other than to ensure the process finished as
soon as posible with a commit or rollback, and no human intervention is
needed in between Begin Transaction and Commit , such as messages on screen
or buttons needed to be pressed, etc?