DynamicFilterLogin Property
The DynamicFilterLogin property returns or sets the user name used when creating a dynamic snapshot. This property provides a value used when the publication is dynamically filtered using the SUSER_SNAME() function.
Applies To
Syntax
object.DynamicFilterLogin [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to a SQLSnapshot object. |
| value | Value to be returned by SUSER_NAME( ) in filter clauses when creating a dynamic snapshot. |
Remarks
Use the DynamicFilterLogin property to set a value for SUSER_SNAME() in filtering when a dynamic snapshot is created. For example, if the subset filter clause "user_id = SUSER_SNAME()" has been specified for an article, and if you set the DynamicFilterLogin property to "rsmith" before calling the Run method of the SQLSnapshot object, only rows having "rsmith" in the user_id column will be included in the snapshot.
The DynamicFilterLogin property applies only to snapshots created for merge publications.
Data Type
String
Modifiable
Read/write
Prototype C/C++
HRESULT get_DynamicFilterLogin(BSTR *pVal);
HRESULT put_DynamicFilterLogin(BSTR newVal);