I understand proc exec option as for example when you run a procedure which inserts 1000 records into table, those insert afterwards will be replicated to the subscriber. When it comes to 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?

Your Answer

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

Browse other questions tagged or ask your own question.