Returns information about a publication.
sp_helppublication [[@publication =] 'publication']
| 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 |
| 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 the Snapshot Agent is completed once for the immediate_sync publication. It has no definition for a nonimmediate_sync publication. |
| 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 days, to save for the given publication. |
sp_helppublication is used in snapshot and transactional replication.
Execute permissions default to the public role.