hi we run 2014 enterprise. one of my sql scripts contains 2 updates and about 10 inserts.
i'm looking at its properties and 2 stand out, iso level serializable and tran option supported.
by any chance is this running as a single tran or do i need to wrap it in a tran or change the properties to accomolish that? I want it to roll back if there is a failure.