后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。
The UpdateAgentProfile method alters a profile setting for the agent specified.
语法
object
.UpdateAgentProfile(
DistributionDB
,
AgentType
,
AgentID
,
ConfigurationID
)
Parts
- object
Expression that evaluates to an object in the Applies To list.
- DistributionDB
String.
- AgentType
Long integer that specifies a replication agent type as described in Settings.
- AgentID
Long integer.
- ConfigurationID
Long integer.
Prototype (C/C++)
HRESULT UpdateAgentProfile(
SQLDMO_LPCSTR DistributionDBName,
SQLDMO_REPLAGENT_TYPE AgentType,
long lAgentID,
long lConfigurationID);
Settings
Set the AgentType argument by using these SQLDMO_REPLAGENT_TYPE values.
| Constant | Value | Description |
|---|---|---|
SQLDMOReplAgent_Distribution |
3 |
Replication Distribution Agent. |
SQLDMOReplAgent_LogReader |
2 |
Replication transaction log monitoring agent. |
SQLDMOReplAgent_Merge |
4 |
Replication Merge Agent. |
SQLDMOReplAgent_/QueueReader |
9 |
Replication Queue Reader Agent. |
SQLDMOReplAgent_Snapshot |
1 |
Replication Snapshot Agent. |
备注
Changing a replication agent profile setting by using the UpdateAgentProfile method requires appropriate permission. The SQL Server login used for SQLServer object connection must be a member of the fixed role sysadmin.
Applies To:
|