Subscription Properties
The Subscription Properties page in SQL Server Management Studio enables you to see the properties that are set for a subscription and modify some of those properties. The Subscription Properties page is not available in SQL Server Management Studio Express.
Options
Property Name | Value |
---|---|
Subscriber |
The name of the computer or device that has a subscription to the publication. This property can only be set once at the time when the subscription is created. |
Publisher |
The name of the computer where the publication was created. This property can only be set once at the time when the subscription is created. |
PublisherDatabase |
The name of the database from which a publication has been created. This property can only be set once at the time when the subscription is created. |
Publication |
The name of the publication. This property can only be set once at the time when the subscription is created. |
HostName |
Set the HOST_NAME() value if the merge publication is defined with parameterized filters using the HOST_NAME() function to filter data. |
InternetUrl |
Displays the SQL Server Compact 3.5 virtual directory on the Web server running Internet Information Services (IIS). |
Internet Login |
If needed for Web server authentication, this field displays the user name needed for login. |
InternetPassword |
If needed for Web server authentication, this field displays the password needed for login. |
PublisherSecurityMode |
Identifies whether SQL Server Authentication or Windows Authentication is being used. |
PublisherLogin |
Displays the user name required for login to the Publisher. This property can only be set once at the time when the subscription is created. |
PublisherPassword |
Displays the password required to logon to the Publisher. This property can only be set once at the time when the subscription is created. |