logmarkhistory (Transact-SQL)
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). |
