Export (0) Print
Expand All

syssubscriptions (System View) (Transact-SQL)

The syssubscriptions view exposes subscription information. This view is stored in the distribution database.

Column name

Data type

Description

artid

int

The unique ID of a subscribed article.

srvid

smallint

The server ID of the Subscriber.

dest_db

sysname

The name of the subscription 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 connecting to the Publisher to add 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)

Identifies the Distribution Agent job used to synchronize the subscription.

timestmap

timestamp

The date and time that the subscription was created.

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.

3 = Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

srvname

sysname

The name of the Subscriber.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft