SQL will automatically try to run all scripts inside a transaction unless the script is calling some stored procedures that cannot run within a transaction.
This list is stored in a file called Transactions.xml located in your installation directory. You are able to add more to this list if you need to.