UpdateAgentProfile Method
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The UpdateAgentProfile method alters a profile setting for the agent specified.
Sintaxis
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. |
Notas
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:
|