Returns a list of subscribers who have subscribed to all articles in a specified publication.
sp_enumfullsubscribers publication
where
This example returns a list of all subscribers who have subscribed to all articles in the publication pub3.
sp_enumfullsubscribers pub3
Execute permission defaults to the system administrator and the database owner.
sysarticles, syspublications, syssubscriptions, sysservers
| sp_addarticle | sp_droparticle |
| sp_addpublication | sp_droppublication |
| sp_articlecolumn | sp_helparticle |
| sp_changearticle | sp_helparticlecolumns |
| sp_changepublication | sp_helppublication |