sp_dropanonymousagent (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Topic link icon Transact-SQL Syntax Conventions

Syntax


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

Arguments

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

Remarks

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.

Permissions

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

See Also

Replication Stored Procedures (Transact-SQL)