sp_change_subscription_properties (T-SQL)

Updates the security information in the MSsubscription_properties table.

Syntax

sp_change_subscription_properties [@publisher =] 'publisher',
[@publisher_db =] 'publisher_db', [@publication =] 'publication',
[@property =] 'property', [@value =] 'value'

Arguments

[@publisher =] 'publisher'

Is the name of the Publisher. publisher is sysname, with no default.

[@publisher_db =] 'publisher_db'

Is the name of the Publisher database. publisher_db is sysname, with no default.

[@publication =] 'publication'

Is the name of the publication. publication is sysname, with no default.

[@property =] 'property'

Is the property to be changed. property is sysname, and can be one of these values.

Value	Description
publisher_login	Publisher login.
Publisher_password	Publisher password.
Publisher_security_mode	Security mode implemented at the Publisher. Can be: 0 = SQL Server Authentication 1 = Windows NT Authentication
distributor_login	Distributor login.
Distributor_password	Distributor password.
Distributor_security_mode	Security mode implemented at the Distributor. Can be: 0 = SQL Server Authentication 1 = Windows NT Authentication
encrypted_distributor_password	For internal use only.
Ftp_address	Network address of the FTP service for the Distributor.
Ftp_port	Port number of the FTP service for the Distributor.
Ftp_login	Username used to connect to the FTP service.
Ftp_password	User password used to connect to the FTP service.

[@value =] 'value'

Is the new value of the property. value is sysname, with no default.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_change_subscription_properties is used in all types of replication.

Permissions

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_change_subscription_properties.