sp_enumfullsubscribers (T-SQL)

Returns a list of Subscribers who have subscribed to all articles in a specified publication.

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, transactional, and merge replication.

Permissions

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_enumfullsubscribers.

See Also
sp_addarticle sp_droppublication
sp_addpublication sp_helparticle
sp_articlecolumn sp_helparticlecolumns
sp_changearticle sp_helppublication
sp_changepublication System Stored Procedures
sp_droparticle  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.