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

Fix up that logic there and provide some tests and I think we are in business.