Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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

Specifies the type of initialization when sync_type = 2, and can be one of the following values:

0 = none - Subscriber already has the schema and initial data for published tables. This option has been deprecated.

1 = replication support only - provides automatic generation at the Subscriber of article custom stored procedures and triggers that support updating subscriptions. Assumes that Subscriber already has the schema and initial data for published tables.

2 = initialize with backup - Schema and initial data for published tables are obtained from a backup of the publication database. Assumes that the Subscriber has access to a backup of the publication database.

3 = For internal use only.

Community Additions

ADD
Show:
© 2015 Microsoft