Transact-SQL Reference
sp_enumfullsubscribers
Returns a list of Subscribers who have subscribed to all articles in a specified publication. This stored procedure is executed at the Publisher on the publication database.
Syntax
sp_enumfullsubscribers [ [ @publication =] 'publication']
Arguments
[@publication = ] 'publication'
Is the name of the publication. publication is sysname, with a default of %. If publication is not specified, all publications are returned.
Return Code Values
0 (success) or 1 (failure)
Result Set
| Column name | Data type | Description |
|---|---|---|
| subscriber | sysname | Name of the subscribing server |
Remarks
sp_enumfullsubscribers is used in snapshot replication, transactional replication, and merge replication.
Permissions
Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_enumfullsubscribers.