MSmerge_tombstone (Transact-SQL)
The MSmerge_tombstone table contains information on deleted rows and allows deletes to be propagated to other Subscribers. This table is stored in the publication and subscription databases.
| Column name | Data type | Description |
|---|---|---|
rowguid |
uniqueidentifier |
The row identifier. |
tablenick |
int |
The nickname of the table. |
type |
tinyint |
The type of delete: 1 = User delete. 5 = Row no longer belongs to the filtered partition. 6 = System delete. |
lineage |
varbinary(249) |
Indicates the version of the record that was deleted, and which updates were known when it was deleted. Allows rules for consistent resolution of a conflict when one Subscriber updates a row while it is being deleted at another Subscriber. |
generation |
int |
Is assigned when a row is deleted. If a Subscriber requests generation N, only tombstones with generation >= N are sent. |
logical_record_parent_rowguid |
uniqueidentifier |
Identifies the logical record to which a deleted row belongs. |
logical_record_lineage |
Varbinary(501) |
The subscriber nickname, version number pairs that are used to maintain a history of deletes for the logical record to which this row belongs. |
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables