Contains rows for the parameter information for pull Distribution Agents. This table is stored in the Subscriber database.
| Column name | Data type | Description |
|---|---|---|
| publisher | sysname | Name of the Publisher. |
| publisher_db | sysname | Name of the Publisher database. |
| publication | sysname | Name of the publication. |
| publication_type | int | Type of publication: 0 = Transactional 2 = Merge |
| publisher_login | sysname | Login ID used at the Publisher for SQL Server Authentication. |
| publisher_password | sysname | Password (encrypted) used at the Publisher for SQL Server Authentication. |
| publisher_security_mode | int | Security mode implemented at the Publisher: 0 = SQL Server Authentication 1 = Windows NT Authentication 2 = The synchronization triggers use a static sysservers entry to do RPC, and publisher must be defined in the sysservers table as a remote server or linked server. |
| distributor_login | sysname | Login ID used at the Distributor for SQL Server Authentication. |
| distributor_password | sysname | Password (encrypted) used at the Distributor for SQL Server Authentication. |
| distributor_security_mode | int | Security mode implemented at the Distributor: 0 = SQL Server Authentication 1 = Windows NT Authentication |
| ftp_address | sysname | Network address of the FTP service for the Distributor. |
| ftp_port | int | Port number of the FTP service for the Distributor. |
| ftp_login | sysname | Username used to connect to the FTP service. |
| ftp_password | sysname | User password used to connect to the FTP service. |