后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。
The CreateAgentProfile method creates a replication agent profile.
语法
object
.CreateAgentProfile(
bstrName
,
bstrDescription
,
ReplAgentType
)
as
Long
Parts
- object
Expression that evaluates to an object in the Applies To list.
- bstrName
String that specifies profile name.
- bstrDescription
String that contains descriptive text.
- ReplAgentType
Long integer that specifies a replication agent type as described in Settings.
Prototype (C/C++)
HRESULT CreateAgentProfile(SQLDMO_LPCSTR szName,
SQLDMO_LPCSTR szDescription,
SQLDMO_REPLAGENT_TYPE AgentType, long *plProfileID);
Settings
Set the ReplAgentType argument 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 |
Returns
A system-generated, long integer that identifies the agent profile.
备注
Use the CreateAgentProfile method to add a replication agent profile to a Distributor. The new profile is a copy of the default profile in use for the agent.
Use the ChangeAgentParameter method to modify parameter values and change the behaviors configured by the newly created profile.