Displays the profile of a specified agent. This stored procedure is executed at the Distributor on any database.
Is the type of agent. agent_type is int, with a default of 0, and can be one of these values.
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.
Specifies whether this profile is the default for this agent type.
sp_help_agent_profile is used in all types of replication.
Only members of the sysadmin fixed server role or the replmonitor fixed database role can execute sp_help_agent_profile.