Transact-SQL Reference
syspublications
Contains one row for each publication defined in the database. This table is stored in the publication database.
| Column name | Data type | Description |
|---|---|---|
| description | nvarchar(255) | Descriptive entry for the publication. |
| name | sysname | Unique name associated with the publication. |
| pubid | int | Identity column providing a unique ID for the publication. |
| repl_freq | tinyint | Replication frequency:
0 = Transaction based. |
| status | tinyint | Status:
0 = Inactive. |
| sync_method | tinyint | Synchronization method:
0 = Native bulk copy program (bcp utility). |
| snapshot_jobid | binary(16) | Scheduled task ID. |
| independent_ agent |
bit | Specifies whether there is a stand-alone Distribution Agent for this publication.
0 = The publication uses a shared Distribution Agent, and each Publisher database/Subscriber database pair has a single, shared Agent. |
| immediate_sync | bit | Indicates whether the synchronization files are created or re-created each time the Snapshot Agent runs. |
| enabled_for_ internet |
bit | Indicates whether the synchronization files for the publication are exposed to the Internet through FTP and other services. |
| allow_push | bit | Indicates whether push subscriptions are allowed on the publication. |
| allow_pull | bit | Indicates whether pull subscriptions are allowed on the publication. |
| allow_anonymous | bit | Indicates whether anonymous subscriptions are allowed on the publication. |
| immediate_sync_ ready |
bit | Indicates whether the snapshot has been generated by the Snapshot Agent and is ready for use by new subscriptions. It is only meaningful for immediate updating publications. 0 indicates that there is no snapshot ready. |
| allow_sync_tran | bit | Specifies whether immediate-updating subscriptions are allowed on the publication. 0 means that immediate-updating subscriptions are not allowed. |
| autogen_sync_ procs |
bit | Specifies whether the synchronizing stored procedure for immediate-updating subscriptions is generated at the Publisher. 1 means that it is generated at the Publisher. |
| retention | int | Amount of change, in hours, to save for the given publication. |
| allowed_queued_tran | bit | Specifies whether disables queuing of changes at the Subscriber until they can be applied at the Publisher has been enabled. If 0, changes at the Subscriber are not queued. |
| snapshot_in_defaultfolder | bit | Specifies whether snapshot files are stored in the default folder. If 0, snapshot files have been stored in the alternate location specified by alternate_snapshot_folder. If 1, snapshot files can be found in the default folder. |
| alt_snapshot_folder | nvarchar(255) | Specifies the location of the alternate folder for the snapshot. |
| pre_snapshot_script | nvarchar(255) | Specifies a pointer to an .sql file location. The Distribution Agent will run the pre-snapshot script before running any of the replicated object scripts when applying a snapshot at a Subscriber. |
| post_snapshot_script | nvarchar(255) | Specifies a pointer to an .sql file location. The Distribution Agent will run the post-snapshot script after all the other replicated object scripts and data have been applied during an initial synchronization. |
| compress_snapshot | bit | Specifies that the snapshot that is written to the @alt_snapshot_folder location is to be compressed into the Microsoft® CAB format. 0 specifies that the snapshot will not be compressed. |
| ftp_address | sysname | The network address of the FTP service for the Distributor. Specifies where publication snapshot files are located for the Distribution Agent or Merge Agent of a subscriber to pick up. |
| ftp_port | int | The port number of the FTP service for the Distributor. Specifies where the publication snapshot files are located for the Distribution Agent or Merge Agent of a subscriber to pick up |
| ftp_subdirectory | nvarchar(255) | Specifies where the snapshot files will be available for the Distribution Agent or Merge Agent of subscriber to pick up if the publication supports propagating snapshots using FTP. |
| ftp_login | sysname | The username used to connect to the FTP service. |
| ftp_password | nvarchar(524) | The user password used to connect to the FTP service. |
| allow_dts | bit | Specifies that the publication allows data transformations. 0 specifies that DTS transformations are not allowed. |
| allow_subscription_copy | bit | Specifies whether the ability to copy the subscription databases that subscribe to this publication has been enabled. 0 means that copying is not allowed. |
| centralized_conflicts | bit | Specifies whether conflict records are stored on the Publisher:
0 = Conflict records are stored at both the publisher and at the subscriber that caused the conflict. |
| conflict_retention | int | Specifies the conflict retention period, in days. |
| conflict_policy | int | Specifies the conflict resolution policy followed when the queued updating subscriber option is used. Can be one of these values:
1 = Publisher wins the conflict. |
| queue_type | int | Specifies which type of queue is used. Can be one of these values:
msmq = Use Microsoft Message Queuing to store transactions. |
| ad_guidname | sysname | Specifies whether the publication is published in the Microsoft Active Directory™. A valid globally unique identifier (GUID) specifies that the publication is published in the Microsoft Active Directory, and the GUID is the corresponding Active Directory publication object objectGUID. If NULL, the publication is not published in Microsoft Active Directory. |
| backward_comp_level | int | Database compatibility level (60, 65, 70, and 80). |