Transact-SQL Reference
MSsubscription_properties
The MSsubscription_properties table contains rows for the parameter information for pull Distribution Agents. This table is stored in the subscription 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 |
| 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 |
| distributor | sysname | Name of the Distributor. |
| 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 |
| 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. |
| alt_snapshot_folder | nvarchar(255) | Specifies the location of the alternate folder for the snapshot. |
| working_directory | nvarchar(255) | Name of the working directory used to store data and schema files. |
| use_ftp | bit | Specifies the use of FTP instead of the regular protocol to retrieve snapshots. If 1, FTP is used. |
| dts_package_name | sysname | Specifies the name of the DTS package. |
| dts_package_password | nvarchar(524) | Specifies the password on the package, if there is one. A value of NULL means that the package has no password. |
| dts_package_location | int | Location where the DTS package is stored. |
| enabled_for_syncmgr | bit | Specifies whether the subscription can be synchronized through the Microsoft Synchronization Manager. If 0, subscription is not registered with Synchronization Manager. If 1, subscription is registered with Synchronization Manager and can be synchronized without starting SQL Server Enterprise Manager. |
| offload_agent | bit | Specifies if the agent can be activated remotely. If 0, the agent cannot be activated remotely. |
| offload_server | sysname | Specifies the network name of the server used for remote activation. |
| dynamic_snapshot_location | nvarchar(255) | Specifies the path to the folder where the snapshot files are saved. |