logmarkhistory (Transact-SQL)

Applies to: SQL Server

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)	Local database where marked transaction occurred.
mark_name	nvarchar(128)	User-provided name for marked transaction.
description	nvarchar(255)	User-provided description of the marked transaction. Can be NULL.
user_name	nvarchar(128)	Database user name that performed marked transaction. Can be NULL.
lsn	numeric(25,0)	Log sequence number of transaction record where mark occurred.
mark_time	datetime	Commit time of marked transaction (local time).

See Also