| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSsubscriber_info (Transact-SQL) |
MSsubscriber_info (Transact-SQL) |
VanMSFT |
vanto |
03/14/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server]
The MSsubscriber_info table contains one row for each Publisher/Subscriber pair that is being pushed subscriptions from the local Distributor. This table is stored in the distribution database.
Note This system table has been deprecated and is being maintained to support previous versions of [!INCLUDEmsCoName] [!INCLUDEssNoVersion].
| Column name | Data type | Description |
|---|---|---|
| publisher | sysname | The name of the Publisher. |
| subscriber | sysname | The name of the Subscriber. |
| type | tinyint | The subscriber type: 0 = [!INCLUDEssNoVersion] Subscriber. 1 = ODBC data source. |
| login | sysname | The login for [!INCLUDEssNoVersion] Authentication. Stored in encrypted format if Subscriber is added with [!INCLUDEssNoVersion] Authentication mode. |
| password | nvarchar(524) | The password for [!INCLUDEssNoVersion] Authentication. Stored in encrypted format if Subscriber is added with [!INCLUDEssNoVersion] Authentication mode. |
| description | nvarchar(255) | The description of the Subscriber. |
| security_mode | int | The implemented security mode: 0 = [!INCLUDEssNoVersion] Authentication. 1 = [!INCLUDEmsCoName] Windows Authentication. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)