Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

  New Information - SQL Server 2000 SP3.

Drops an anonymous agent for replication monitoring at the distributor from the Publisher. This stored procedure is executed at the Publisher on any database.


sp_dropanonymousagent [ @subid = ] sub_id
[ @type = ] type


[@subid = ] sub_id

Is the global identifier for an anonymous subscription. sub_id is uniqueidentifier, with no default. This identifier can be retrieved at the Subscriber using sp_helppullsubscription. The value in the subid field of the returned result set is this global identifier.

[@type = ] type

Is the type of subscription. type is int, with no default. Valid values are 1 or 2. Specify 1, if snapshot replication or transactional replication using the Distribution Agent. Specify 2, if merge replication using the Merge Agent.

Return Code Values

0 (success) or 1 (failure)


sp_dropanonymousagent is used in all types of replication.

This stored procedure is used to drop anonymous subscription agents only and cannot be used to drop well-known subscriptions.


Only members of the sysadmin fixed server role or db_owner fixed database role or the login of the user that initiated the first run of the agent can execute sp_dropanonymousagent.

© 2015 Microsoft