title: Would transaction work across multiple DB in the same SQL server? If so, is this a Distributed transaction?
body: <p>Would transaction work across multiple DB in the same SQL server?
  If so, is this a Distributed transaction? or would basic <code>BEGIN TRANSACTION</code> work?</p>