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.
sp_enumfullsubscribers [ [ @publication =] 'publication']
[@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)
|Column name||Data type||Description|
|subscriber||sysname||Name of the subscribing server|
sp_enumfullsubscribers is used in snapshot replication, transactional replication, and merge replication.
Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_enumfullsubscribers.