Question of the Day

Multi-Database Marked Transactions

I run a marked transaction across multiple databases with this code:

BEGIN TRAN onemorenewdbTran WITH MARK 'mark from 3 dbs'
USE sandbox2
INSERT dbo.AddressTable
  (AddressID, AddressValue, AddressPostal)
VALUES
  (12, '123 three St', '4444')
GO
USE sandbox3
INSERT dbo.Logger (logdate, logmsg) VALUES (GETDATE(), 'tran message')
GO
INSERT sandbox4.dbo.logger (uid) VALUES (700)
COMMIT TRAN onemorenewdbTran
GO

How many marks are inserted into msdb.dbo.logmarkhistory?

See possible answers