Share via


syssubscriptions (Transact-SQL)

Contains one row for each subscription in the database. This table is stored in the publication database.

Column name Data type Description

artid

int

The unique ID of an article.

srvid

smallint

The server ID of the Subscriber.

dest_db

sysname

The name of the destination database.

status

tinyint

The status of the subscription:

0 = Inactive.

1 = Subscribed.

2 = Active.

sync_type

tinyint

The type of initial synchronization:

1 = Automatic.

2 = None

login_name

sysname

The login name used when adding the subscription.

subscription_type

int

The type of subscription:

0 = Push - the distribution agent runs at the Subscriber.

1 = Pull - the distribution agent runs at the Distributor.

distribution_jobid

binary(16)

The job ID of the Distribution Agent.

timestamp

timestamp

The timestamp.

update_mode

tinyint

The update mode:

0 = Read only.

1 = Immediate-updating.

loopback_detection

bit

Applies to subscriptions that are part of a bidirectional transactional replication topology. Loopback detection determines whether the Distribution Agent sends transactions originated at the Subscriber back to the Subscriber:

0 = Sends back.

1 = Does not send back.

queued_reinit

bit

Specifies whether the article is marked for initialization or reinitialization. A value of 1 specifies that the subscribed article is marked for initialization or reinitialization.

nosync_type

tinyint

The type of subscription initialization:

0 = Automatic (snapshot)

1 = Replication support only

2 = Initialize with backup

3 = Initialize from log sequence number (LSN)

For more information, see the @sync_type parameter of sp_addsubscription.

srvname

sysname

The name of the Subscriber.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

15 September 2007

New content:
  • Added information about nosync_type and srvname columns.