Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


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.

© 2016 Microsoft