Edit

sp_dropanonymousagent (Transact-SQL)

  • Article

Applies to: SQL Server

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

Transact-SQL syntax conventions

Syntax

sp_dropanonymousagent
    [ @subid = ] 'subid'
    , [ @type = ] type
[ ; ]

Arguments

[ @subid = ] 'subid'

The global identifier for an anonymous subscription. @subid 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

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).

Remarks

sp_dropanonymousagent is used in all types of replication.

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

Permissions

Only members of the db_owner fixed database role in the distribution database can execute sp_dropanonymousagent.

Related content