Displays information about a publication.
sp_helppublication [publication]
where
This stored procedure displays the publication ID, the name, whether the publication is unrestricted/restricted, the status, the SQL Executive task ID, the replication frequency, the synchronization method, and a description. If publication is not provided, information on all publications is returned.
This example displays information about the mypub5 publication.
sp_helppublication mypub5
Execute permission defaults to the public group.
sysarticles, syspublications, syssubscriptions, sysservers
sp_addarticle | sp_droparticle |
sp_addpublication | sp_droppublication |
sp_articlecolumn | sp_enumfullsubscribers |
sp_changearticle | sp_helparticle |
sp_changepublication | sp_helparticlecolumns |