sp_dropanonymousagent (Transact-SQL)
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
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho