Export (0) Print
Expand All
Expand Minimize


SQL Server 2000

  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.

Result Sets
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
1 = Scheduled table refresh

synchronization method tinyint Synchronization mode:

0 = Native bulk copy program (bcp utility)
1 = Character bulk copy
3 = Concurrent, which means that native bulk copy (bcp utility) is used but tables are not locked during the snapshot
4 = Concurrent_c, which means that character bulk copy is used but tables are not locked during the snapshot

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.

See Also











System Stored Procedures

© 2014 Microsoft