共用方式為


Subscription.SynchronizationAgentName 屬性

Gets or sets the name of the agent job created to synchronize the subscription.

命名空間:  Microsoft.SqlServer.Replication
組件:  Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)

語法

'宣告
Public Property SynchronizationAgentName As String 
    Get 
    Set
'用途
Dim instance As Subscription 
Dim value As String 

value = instance.SynchronizationAgentName

instance.SynchronizationAgentName = value
public string SynchronizationAgentName { get; set; }
public:
property String^ SynchronizationAgentName {
    String^ get ();
    void set (String^ value);
}
member SynchronizationAgentName : string with get, set
function get SynchronizationAgentName () : String 
function set SynchronizationAgentName (value : String)

屬性值

型別:System.String
The name of the agent created to synchronize the subscription.

備註

The SynchronizationAgentName property is a read/write property on Microsoft SQL Server 2005. It is a ready-only property of Microsoft SQL Server 2000.

SynchronizationAgentName must be set before the subscription is created on the server. Once the subscription registration exists on the server, the SynchronizationAgentName property cannot be changed.

The SynchronizationAgentName property can only be retrieved by members of the sysadmin fixed server role at the Publisher, by members of the db_owner fixed database role on the publication database, or by the user that created the subscription.

The SynchronizationAgentName property can only be set by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.

Retrieving the SynchronizationAgentName property is equivalent to executing sp_helpsubscription or sp_helpmergesubscription.

Setting the SynchronizationAgentName property is equivalent to executing sp_addpushsubscription_agent or sp_addmergepushsubscription_agent.

請參閱

參考

Subscription 類別

Microsoft.SqlServer.Replication 命名空間