SnapshotGenerationAgent.DynamicFilterLogin プロパティ
Gets or sets the value supplied to the SUSER_SNAME function used in a parameterized row filter.
名前空間: Microsoft.SqlServer.Replication
アセンブリ: Microsoft.SqlServer.Replication (Microsoft.SqlServer.Replication.dll)
構文
'宣言
Public Property DynamicFilterLogin As String
Get
Set
'使用
Dim instance As SnapshotGenerationAgent
Dim value As String
value = instance.DynamicFilterLogin
instance.DynamicFilterLogin = value
public string DynamicFilterLogin { get; set; }
public:
virtual property String^ DynamicFilterLogin {
String^ get () sealed;
void set (String^ value) sealed;
}
abstract DynamicFilterLogin : string with get, set
override DynamicFilterLogin : string with get, set
final function get DynamicFilterLogin () : String
final function set DynamicFilterLogin (value : String)
プロパティ値
型: System.String
A String value used for filtering.
実装
ISnapshotGenerationAgent.DynamicFilterLogin
説明
The value specified for DynamicFilterLogin is used when generating the partitioned snapshot for a subscription defined based-on a parameterized row filter that uses the SUSER_SNAME function. For example, if the subset filter clause LoginID = SUSER_SNAME() is specified for an article, and you set the DynamicFilterLogin property to "adventure-works\garrett1" before calling the Merge Agent, only rows having "adventure-works\garrett1" in the login_id column will be replicated.
The DynamicFilterLogin property is only supported for merge publications.
You should not specify a value for DynamicFilterLogin when specifying a value for DynamicFilterHostName.
関連項目
参照
Microsoft.SqlServer.Replication 名前空間
その他の技術情報
パラメーター化されたフィルターを使用してマージ パブリケーションのスナップショットを作成する方法 (RMO プログラミング)