sp_enumfullsubscribers

Transact-SQL Reference

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.

See Also

sp_addarticle

sp_addpublication

sp_articlecolumn

sp_changearticle

sp_changepublication

sp_droparticle

sp_droppublication

sp_helparticle

sp_helparticlecolumns

sp_helppublication

System Stored Procedures