logmarkhistory

Transact-SQL Reference

Transact-SQL Reference

logmarkhistory

Contains one row for each marked transaction that has been committed. This table is stored in the msdb database.

Column name Data type Description
database_name nvarchar(128) NOT NULL Local database where marked transaction occurred.
mark_name nvarchar(128) NOT NULL User-provided name for marked transaction.
description nvarchar(255) NULL User-provided description of the marked transaction.
user_name nvarchar(128) NULL Database user name that performed marked transaction.
lsn numeric(25,0) NOT NULL Log sequence number of transaction record where mark occurred.
mark_time datetime NOT NULL Commit time of marked transaction (local time).