You can use the @TRANSACTION directive to indicate that the script should be treated as a transaction. If a script is treated as a transaction, Microsoft Transaction Server (MTS) will create a transaction to coordinate the updating of resources.
<%@ TRANSACTION=value %>
|Required||The script will initiate a transaction.|
|Requires_New||The script will initiate a transaction.|
|Supported||The script will not initiate a transaction.|
|Not_Supported||The script will not initiate a transaction.|
If a script contains the @TRANSACTION directive, it must be the very first line in the .asp file, otherwise an error is generated. You must add the directive to each page that should be run under a transaction. The current transaction ends when the script finishes processing.