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
Microsoft.SqlServer.Replication Namespace
Other Resources
NIB Create a Snapshot for a Merge Publication with Parameterized Filters (RMO Programming)