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.|