Export (0) Print
Expand All
Expand Minimize

sp_helpmergepullsubscription

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Returns information about the pull subscription. This stored procedure is executed at the Subscriber on the subscription database.

Syntax

sp_helpmergepullsubscription [ [ @publication =] 'publication']
    [ , [ @publisher =] 'publisher']
    [ , [ @publisher_db =] 'publisher_db']
    [ , [ @subscription_type =] 'subscription_type']

Argument

[@publication = ] 'publication'

Is the name of the publication. publication is sysname, with a default of %. If publication is %, information about all merge publications and subscriptions in the current database is returned.

[@publisher = ] 'publisher'

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

[@publisher_db = ] 'publisher_db'

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

[@subscription_type = ] 'subscription_type'

Is whether to show pull subscriptions. subscription_type is nvarchar(10), with a default of 'pull'. Valid values are 'push', 'pull', or 'both'.

Result Sets
Column name Data type Description
subscription_name nvarchar(1000) Name of the subscription.
publication sysname Name of the publication.
publisher sysname Name of the Publisher.
publisher_db sysname Name of the Publisher database.
subscriber sysname Name of the Subscriber.
subscription_db sysname Name of the subscription database.
status Int Subscription status:

0 = All jobs are waiting to start
1 = One or more jobs are starting
2 = All jobs have successfully executed
3 = At least one job is executing
4 = All jobs are scheduled and idle
5 = At least one job is attempting to execute after a previous failure
6 = At least one job has failed to execute successfully

subscriber_type int Type of Subscriber:

1 = Global
2 = Local
3 = Anonymous

subscription_type int Type of subscription:

0 = Push
1 = Pull
2 = Anonymous

priority float(8) Subscription priority. The value must be less than 100.00.
sync_type tinyint Subscription synchronization type:

1 = Automatic
2 = Nosync

description nvarchar(255) Brief description of this pull subscription.
merge_jobid binary(16) Job ID of the Merge Agent.
enabled_for_synmgr int Whether the subscription can be synchronized through the Microsoft Synchronization Manager.
last_updated nvarchar(26) Date publication was last updated.
publisher_login sysname The Publisher login name.
publisher_password sysname The Publisher password.
publisher_security_mode int Specifies the security mode of the Publisher:

0 = SQL Server Authentication
1 = Windows Authentication

distributor sysname Name of the Distributor.
distributor_login sysname The Distributor login name.
distributor_password sysname The Distributor password.
distributor_security_mode int Specifies the security mode of the Distributor:

0 = SQL Server Authentication
1 = Windows Authentication

ftp_address sysname Available for backward compatibility only. Is the network address of the FTP service for the Distributor.
ftp_port int Available for backward compatibility only. Is the port number of the FTP service for the Distributor.
ftp_login sysname Available for backward compatibility only. Is the username used to connect to the FTP service.
ftp_password sysname Available for backward compatibility only. Is the user password used to connect to the FTP service.
alt_snapshot_folder nvarchar(255) Location where snapshot folder is stored if the location is other than or in addition to the default location.
working_directory nvarchar(255) Fully qualified path to the directory where snapshot files are transferred using FTP when that option is specified.
use_ftp bit Subscription is subscribing to Publication over the Internet and FTP addressing properties are configured. If 0, Subscription is not using FTP. If 1, subscription is using FTP.
offload_agent bit Specifies if the agent can be activated and run remotely. If 0, the agent cannot be remotely activated.
offload_server sysname Name of the server  used for remote activation.
use_interactive_resolver   Returns whether or not the interactive resolver is used during reconciliation. If 0, the interactive resolver is not used.
subid uniqueidentifier ID of the Subscriber.
dynamic_snapshot_location nvarchar(255) The path to the folder where the snapshot files are saved.
last_sync_status int Subscription status:

0 = All jobs are waiting to start
1 = One or more jobs are starting
2 = All jobs have executed successfully
3 = At least one job is executing
4 = All jobs are scheduled and idle
5 = At least one job is attempting to execute after a previous failure
6 = At least one job has failed to execute successfully

last_sync_summary sysname Description of last synchronization results.

Remarks

sp_helpmergepullsubscription is used in merge replication. In the result set, the date returned in last_updated is formatted as YYYYMMDD hh:mm:ss.fff.

Permissions

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

See Also

sp_addmergepullsubscription

sp_changemergepullsubscription

sp_dropmergepullsubscription

System Stored Procedures

Show:
© 2014 Microsoft