sys.sp_changesubscriptiondtsinfo

Description

Changes the Data Transformation Services (DTS) package properties of a subscription. This stored procedure is executed at the Subscriber on the subscription database. The job ID of the Distribution Agent for the push subscription. default. To find the Distribution Job ID, run Specifies the name of the DTS package. For example, to specify a package named Specifies the password on the package.

Syntax

sp_helppullsubscription