what is the difference between replication options proc exec and definition only

  • I understand proc exec option as for example when you run a procedure which inserts 1000 records into table, those inserts afterwards (after they were inserted in Publisher) will be replicated to the subscriber. When it comes to proc schema only (definition only) option, I do not understand how it differentiate from proc exec option. I tested those options on my servers and for me it turned out performing the same thing. I didn't find detailed explanation about these options even on BOL. Could someone explain to me the difference between above two options?

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply