Added option to run scripts before and after the transaction scope

This is a duplicate of a closed pull req. I did, old one was done from master, not very smart so closed that one and did the Pull request from a branch instead

Some configure stuff like
```sql
sp_configure 'Ad Hoc Distributed Queries', 1
reconfigure
```
cant run within the transaction, for these scenarios I added a Before and after transaction folder so you can put these scripts here

Also remove the `reopen_connection` and use `run_in_a_transaction` to determine whether you need to close and reopen the connection. Also opening the connection back up on the after transaction folder may seem wasteful but this may not be the last folder run based on some folks who want the ability to shift around the order.