2010-10-11

Validating one article at one subscriber

Here's a quick script before I nod off:
use [publisher_db]
go
begin tran
go
exec sp_marksubscriptionvalidation 
    @publication = N'publication_name,
    @subscriber = 'subscriber_server',
    @destination_db = 'subscriber_db'
exec sp_article_validation
    @publication = N'publication_name',
    @article = N'article_name',
    @rowcount_only = 2,
    @full_or_fast = 2,
    @shutdown_agent = 0
go
commit


I don't think this is exposed through the GUI at all.

No comments:

Post a Comment