MSsubscription_properties (Transact-SQL)
The MSsubscription_properties table contains rows for the parameter information required to run replication agents at the Subscriber. This table is stored in the subscription database at the Subscriber for a pull subscription or in the distribution database at the Distributor for a push subscription.
| Column name | Data type | Description |
|---|---|---|
publisher |
sysname |
The name of the Publisher. |
publisher_db |
sysname |
The name of the Publisher database. |
publication |
sysname |
The name of the publication. |
publication_type |
int |
The type of publication: 0 = Transactional. 2 = Merge. |
publisher_login |
sysname |
The Login ID used at the Publisher for SQL Server Authentication. |
publisher_password |
nvarchar(524) |
The password (encrypted) used at the Publisher for SQL Server Authentication. |
publisher_security_mode |
int |
Security mode implemented at the Publisher: 0 = Microsoft SQL Server Authentication. 1 = Microsoft Windows Authentication. 2 = The synchronization triggers use a static sysservers entry to do a remote procedure call (RPC), and publisher must be defined in the sysservers table as a remote server or linked server. |
distributor |
sysname |
The name of the Distributor. |
distributor_login |
sysname |
The login ID used at the Distributor for SQL Server Authentication. |
distributor_password |
nvarchar(524) |
The password (encrypted) used at the Distributor for SQL Server Authentication. |
distributor_security_mode |
int |
The security mode implemented at the Distributor: 0 = SQL Server Authentication. 1 = Windows Authentication. |
ftp_address |
sysname |
The network address of the file transfer protocol (FTP) service for the Distributor. |
ftp_port |
int |
The port number of the FTP service for the Distributor. |
ftp_login |
sysname |
The username used to connect to the FTP service. |
ftp_password |
nvarchar(524) |
The u.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) |
The 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 Data Transformation Services (DTS) package. |
dts_package_password |
nvarchar(524) |
Specifies the password on the package. |
dts_package_location |
int |
The location where the DTS package is stored. |
enabled_for_syncmgr |
bit |
Specifies whether the subscription can be synchronized through the Microsoft Synchronization Manager. 0 = Subscription is not registered with Synchronization Manager. 1 = Subscription is registered with Synchronization Manager and can be synchronized without starting SQL Server Management Studio. |
offload_agent |
bit |
Specifies whether the agent can be activated remotely or not. 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. |
use_web_sync |
bit |
Specifies whether the subscription can be synchronized over HTTP or not. A value of 1 means that this feature is enabled. |
internet_url |
nvarchar(260) |
The URL that represents the location of the replication listener for Web synchronization. |
internet_login |
sysname |
The login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using SQL Authentication. |
internet_password |
nvarchar(524) |
The password for the login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using SQL Authentication. |
internet_security_mode |
int |
The authentication mode used when connecting to the Web server that is hosting Web synchronization, where a value of 1 means Windows Authentication, and a value of 0 means SQL Authentication. |
internet_timeout |
int |
The length of time, in seconds, before a Web synchronization request expires. |
hostname |
sysname |
Specifies the value for HOST_NAME when this function is used in the WHERE clause of a join filter or logical record relationship. |
See Also
Reference
Replication Views (Transact-SQL)
sp_helppullsubscription (Transact-SQL)
sp_helpsubscription (Transact-SQL)
sp_helpsubscription_properties (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)