| title | syssubscriptions (System View) (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/06/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | c9613858-9512-43a9-aa53-7ee8064f064c | ||
| caps.latest.revision | 14 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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 Distributor. 1 = Pull - the distribution agent runs at the Subscriber. |
| 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 = [!INCLUDEssInternalOnly] |
| srvname | sysname | The name of the Subscriber. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
syssubscriptions (Transact-SQL)