Would transaction work across multiple DB in the same SQL server? If so, is this a Distributed transaction?

Question

Would transaction work across multiple DB in the same SQL server? If so, is this a Distributed transaction? or would basic BEGIN TRANSACTION work?

Solution 1

A transaction across multiple DBs in the same instance is a local transaction. BEGIN TRANSACTION will work just fine.

Solution 2

Just tested it. BEGIN TRANSACTION works as expected across two databases on the same server.