sp_helppublication Replication Stored Procedure

Displays information about a publication.

Syntax

sp_helppublication [publication]

where

publication

Is the name of the publication to be viewed.

Remarks

This stored procedure displays the publication ID, the name, whether the publication is unrestricted/restricted, the status, the SQL Executive task ID, the replication frequency, the synchronization method, and a description. If publication is not provided, information on all publications is returned.

Example

This example displays information about the mypub5 publication.

sp_helppublication mypub5

Permission

Execute permission defaults to the public group.

Tables Used

sysarticles, syspublications, syssubscriptions, sysservers

See Also