SnapshotGenerationAgent.DynamicFilterLogin Property

Gets or sets the value supplied to the SUSER_SNAME function used in a parameterized row filter.

네임스페이스: Microsoft.SqlServer.Replication
어셈블리: Microsoft.SqlServer.Replication (in microsoft.sqlserver.replication.dll)

구문

‘선언
Public Property DynamicFilterLogin As String
public string DynamicFilterLogin { get; set; }
public:
virtual property String^ DynamicFilterLogin {
    String^ get () sealed;
    void set (String^ value) sealed;
}
/** @property */
public final String get_DynamicFilterLogin ()

/** @property */
public final void set_DynamicFilterLogin (String value)
public final function get DynamicFilterLogin () : String

public final function set DynamicFilterLogin (value : String)

속성 값

A String value used for filtering.

주의

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.

스레드 보안

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

SnapshotGenerationAgent Class
SnapshotGenerationAgent Members
Microsoft.SqlServer.Replication Namespace

관련 자료

How to: Create a Snapshot for a Merge Publication with Parameterized Filters (RMO Programming)
매개 변수가 있는 행 필터