Export (0) Print
Expand All
Expand Minimize

sp_help_agent_profile

SQL Server 2000

Displays the profile of a specified agent. This stored procedure is executed at the Distributor on any database.

Syntax

sp_help_agent_profile [ [ @agent_type = ] agent_type ]
    [ , [ @profile_id = ] profile_id ]

Arguments

[@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.

Result Sets
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.

Remarks

sp_help_agent_profile is used in all types of replication.

Permissions

Execute permissions default to the public role.

See Also

System Stored Procedures

Show:
© 2014 Microsoft