New Information - SQL Server 2000 SP3.
Returns information about a publication. This stored procedure is executed at the Publisher on the publication database.
sp_helppublication [ [ @publication = ] 'publication' ]
[ , [ @found =] found OUTPUT]
[@publication = ] 'publication'
Is the name of the publication to be viewed. publication is sysname, with a default of %, which returns information about all publications.
[@found = ] 'found' OUTPUT
Is a flag to indicate returning rows. found is int and an OUTPUT parameter, with a default of 23456. 1 indicates the publication is found. 0 indicates the publication is not found.
|Column name||Data type||Description|
|pubid||int||ID for the publication.|
|name||sysname||Name of the publication.|
|restricted||int||Not used, set to 0.|
|status||tinyint||When publication data will be available.|
|task||Used for backward compatibility.|
|replication frequency||tinyint||Type of replication frequency:
0 = Transaction based
|synchronization method||tinyint||Synchronization mode:
0 = Native bulk copy program (bcp utility)
|description||nvarchar(255)||Optional description for the publication.|
|immediate_sync||bit||Whether the synchronization files are created or re-created each time the Snapshot Agent runs.|
|enabled_for_internet||bit||Whether the synchronization files for the publication are exposed to the Internet, through FTP and other services.|
|allow_push||bit||Whether push subscriptions are allowed on the publication.|
|allow_pull||bit||Whether pull subscriptions are allowed on the publication.|
|allow_anonymous||bit||Whether anonymous subscriptions are allowed on the publication.|
|independent_agent||bit||Whether there is a stand-alone Distribution Agent for this publication.|
|immediate_sync_ready||bit||Whether or not the Snapshot Agent generated a snapshot that is ready to be used by new subscriptions. This parameter is defined only if the publication is set to always have a snapshot available for new or reinitialized subscriptions.|
|allow_sync_tran||bit||Whether immediate-updating subscriptions are allowed on the publication.|
|autogen_sync_procs||bit||Whether to automatically generate stored procedures to support immediate-updating subscriptions.|
|snapshot_jobid||binary(16)||Scheduled task ID.|
|retention||int||Amount of change, in hours, to save for the given publication.|
sp_helppublication is used in snapshot and transactional replication.
Only members of the sysadmin fixed server role, the db_owner fixed database role, or the publication access list for the current publication can execute sp_helppublication.