MSmerge_dynamic_snapshots (Transact-SQL)
Collapse the table of content
Expand the table of content

MSmerge_dynamic_snapshots (Transact-SQL)


Applies To: SQL Server

The MSmerge_dynamic_snapshots table tracks the location of the filtered data snapshot for each partition defined for a merge publication with parameterized row filters. This table is stored in the publication database.

Column nameData typeDescription
partition_idintThe ID of the merge partition.
dynamic_snapshot_locationnvarchar(255)The location of the filtered data snapshot for the partition.
last_updateddatetimeThe date that the filtered data snapshot was refreshed.

Replication Tables (Transact-SQL)

Community Additions

© 2016 Microsoft