title: Does CHECKPOINT work the same as COMMIT in TSQL?
body: <p>I normally use fully-explicit transactions in my stored procs (BEGIN TRANSACTION .... COMMIT). I just ran across an old one that instead uses "CHECKPOINT" at certain places in the code.</p>
  
  <p>This won't do the same thing, right?? Even if the database is in simple mode, the whole thing will still run as one big transaction, even with a bunch of CHECKPOINTS stuck in the middle?</p>