How to inject additional SQL Code into script
Of course we want this to happen as part of the same transaction.
Is this possible?
We currently use the SQL Compare tool and then modify the script to perform these actions, but of course this cannot be done if we automate this process.
Or is there some way to wrap the current code up so that it uses an external transaction, and we can then perform the actions using normal ADO.NET functionality.