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 name
|
Data type
|
Description
|
|---|
|
partition_id
|
int
|
The ID of the merge partition.
|
|
dynamic_snapshot_location
|
nvarchar(255)
|
The location of the filtered data snapshot for the partition.
|
|
last_updated
|
datetime
|
The date that the filtered data snapshot was refreshed.
|
See Also