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.

See Also

Reference

Replication Views (Transact-SQL)
syssubscriptions (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance