Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSmerge_dynamic_snapshots (Transact-SQL)
Collapse the table of content
Expand the table of content

MSmerge_dynamic_snapshots (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft