Export (0) Print
Expand All
Expand Minimize

sp_enumfullsubscribers

SQL Server 2000

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

Show:
© 2014 Microsoft