sp_helppublicationsync Replication Stored Procedure

Provides information about a scheduled synchronization task for a publication.

Syntax

sp_helppublicationsync publication

where

publication

Is the publication name.

Remarks

Using this stored procedure is the equivalent to running the sp_helptask stored procedures in full mode against the publication task ID.

It returns the information as supplied when the synchronization task was defined. For more information, see the ,sp_addtask SQL Executive Stored Procedure.

Example

This example displays information about the scheduled synchronization task for the mypub publication.

sp_helppublicationsync mypub

Permission

Execute permission defaults to the public group.

See Also