| title | sp_dropanonymousagent (Transact-SQL) | ||
|---|---|---|---|
| description | sp_dropanonymousagent drops an anonymous agent for replication monitoring at the distributor from the Publisher. | ||
| author | VanMSFT | ||
| ms.author | vanto | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | replication | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE 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.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_dropanonymousagent
[ @subid = ] 'subid'
, [ @type = ] type
[ ; ]
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.
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.
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 can't be used to drop well-known subscriptions.
Only members of the db_owner fixed database role in the distribution database can execute sp_dropanonymousagent.