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.
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. |
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.
String
Read/write
HRESULT get_DynamicFilterLogin(BSTR *pVal);
HRESULT put_DynamicFilterLogin(BSTR newVal);