Displays the profile of a specified agent. This stored procedure is executed at the Distributor on any database.
sp_help_agent_profile [ [ @agent_type = ] agent_type ]
[ , [ @profile_id = ] profile_id ]
[@agent_type = ] agent_type
Is the type of agent. agent_type is int, with a default of 0, and can be one of these values.
| Value | Description |
|---|---|
| 1 | Snapshot Agent |
| 2 | Log Reader Agent |
| 3 | Distribution Agent |
| 4 | Merge Agent |
[@profile_id = ] profile_id
Is the ID of the profile to be displayed. profile_id is int, with a default of -1, which returns all the profiles in the MSagent_profiles table.
| Column name | Data type | Description |
|---|---|---|
| profile_id | int | ID of the profile. |
| profile_name | sysname | Unique for agent type. |
| agent_type | int | 1 = Snapshot Agent 2 = Log Reader Agent 3 = Distribution Agent 4 = Merge Agent |
| Type | int | 0 = System 1 = Custom |
| description | varchar(3000) | Description of the profile. |
| def_profile | bit | Specifies whether this profile is the default for this agent type. |
sp_help_agent_profile is used in all types of replication.
Execute permissions default to the public role.