MSsubscription_properties (Transact-SQL)
Applies to:
SQL Server
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 Server 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 Server 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 Server 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
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sp_helppullsubscription (Transact-SQL)
sp_helpsubscription (Transact-SQL)
sp_helpsubscription_properties (Transact-SQL)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho