On your distributor:
SELECT * FROM distribution.dbo.MSpublisher_databases
That gives you a list of the source databases from the publishers. You want the ID field.
Now,
use distribution
go
sp_browsereplcmds @publisher_database_id = 13
will list all the waiting commands. The command field is the actual command, while the article_id can be gotten from running the following on the publisher:
sp_helparticle @publication = 'your_publication_name'
No comments:
Post a Comment