Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

sp_help_agent_default

SQL Server 2000

Retrieves the ID of the default configuration for the agent type passed as parameter. This stored procedure is executed at Distributor on any database.

Syntax

sp_help_agent_default [ @profile_id = ] profile_id OUTPUT
    , [ @agent_type = ] agent_type

Arguments

[@profile_id = ] profile_id OUTPUT

Is the ID of the default configuration for the type of agent. profile_id is int, with no default. profile_id is also an OUTPUT parameter and returns the ID of the default configuration for the type of agent.

[@agent_type = ] 'agent_type'

Is the type of agent. agent_type is int, with no default, and can be one of these values.

Value Description
1 Snapshot Agent.
2 Log Reader Agent.
3 Distribution Agent.
4 Merge Agent.

Remarks

sp_help_agent_default is used in all types of replication.

Permissions

Execute permissions default to the public role.

See Also

System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.