sys.sp_help_agent_parameter

Description

Returns all the parameters of a profile from the procedure is executed at the Distributor where the agent is running, on any database. The ID of the profile from the , which returns all parameters.

Syntax

sp_help_agent_parameter [ [ @profile_id = ] profile_id ]
[ ; ]

Permissions

is used in all types of replication. Only members of the fixed server role or the fixed database role can execute. Work with Replication Agent Profiles sp_add_agent_parameter (Transact-SQL) sp_drop_agent_parameter (Transact-SQL) System stored procedures (Transact-SQL)