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.
| Column name | Data type | Description |
|---|---|---|
| publisher | sysname | Name of the Publisher. |
| subscriber | sysname | Name of the Subscriber. |
| type | tinyint | Subscriber type:
0 = Microsoft® SQL Server™ Subscriber |
| login | sysname | Login for SQL Server Authentication. Stored in encrypted format if Subscriber is added with SQL Server Authentication mode. |
| password | nvarchar(524) | Password for SQL Server Authentication. Stored in encrypted format if Subscriber is added with SQL Server Authentication mode. |
| description | nvarchar(255) | Description of the Subscriber. |
| security_mode | int | Implemented security mode:
0 = SQL Server Authentication |