title: The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION, but still getting an error
body: <p>Simple query:
  Before the UPDATE, the value of EffectiveStartDt is NULL
  After the UPDATE and the ROLLBACK, I want it to go back to NULL</p>
  <pre><code>begin tran t1
  update MasterPayor 
  set EffectiveStartDt = '2020-09-17' 
  where MasterPayorId = 1
  commit
  
  rollback tran t1
  </code></pre>
  <p>I have defined the transactions, but I'm still getting the Rollback error</p>