Running scripts: Transactions

There is no ambient transaction wrapped around a run. Disposing the connection at the end of a target rolls back anything left open and releases its locks. If you want a transaction, write one in your script.