Share via


MergePullSubscription.DynamicSnapshotLocation Property

Gets or sets the file location for the subscription-specific snapshot files when the publication uses a parameterized row filter.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public Property DynamicSnapshotLocation As String 
    Get 
    Set
'Usage
Dim instance As MergePullSubscription 
Dim value As String 

value = instance.DynamicSnapshotLocation

instance.DynamicSnapshotLocation = value
public string DynamicSnapshotLocation { get; set; }
public:
property String^ DynamicSnapshotLocation {
    String^ get ();
    void set (String^ value);
}
member DynamicSnapshotLocation : string with get, set
function get DynamicSnapshotLocation () : String 
function set DynamicSnapshotLocation (value : String)

Property Value

Type: System.String
A String value.

Remarks

The DynamicSnapshotLocation property can only be retrieved by members of the sysadmin fixed server role at the Subscriber or by members of the db_owner fixed database role on the subscription database.

The DynamicSnapshotLocation property can only be set by members of the sysadmin fixed server role at the Subscriber or by members of the db_owner fixed database role on the subscription database.

Retrieving the DynamicSnapshotLocation property is equivalent to executing sp_helpmergepullsubscription.

Setting the DynamicSnapshotLocation property is equivalent to executing sp_addmergepullsubscription_agent or sp_changemergepullsubscription.

See Also

Reference

MergePullSubscription Class

Microsoft.SqlServer.Replication Namespace

Other Resources

NIB Create a Snapshot for a Merge Publication with Parameterized Filters (RMO Programming)