4

I am using merge replication with pull subscriptions and Web Sync.

What is the easiest way to start a SQL script on the publication database when a subscriber starts the synchronization process?

There is this, sp_addscriptexec, but that specifies a script to run at the subscription database which isn't what I am after.

1

There isn't a built-in or easy way to do this with Web Synchronization. You're best bet is to programmatically monitor Merge Agent sessions at the Publisher/Distributor using sp_replmonitorhelpmergesession and sp_replmonitorhelpmergesessiondetail. You can script this out and poll on a schedule.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.