I would say 'Work is part of my life but not my life'

I just modify a little your testing scenario by starting explicit transaction after creating table.

So please execute the following

CREATE TABLE dbo.TestTableSize

(

MyKeyField VARCHAR(10) NOT NULL,

MyDate1 DATETIME NOT NULL,

MyDate2 DATETIME NOT...

Please provide details of your testing.

Job could be connected to SQL Alert or schedule to run.

There is another approach to Monitoring long Running Transactions implemented through store procedure and SQL job executing procedure on predefine schedule.

Procedure will be executed against all databases on given SQL...

Excellent article

The question was which transaction changes will be contain in the full backup?

In my understanding all transaction changes until the point where backup finish are recorded in the backup file....