I have a Push Transactional replication process. I use the GUI to add multiple stored procs as articles. But during the sync process to the subscriber it fails with different messages, depending on what is wrong.
One example is a proc that errors with Unable to replicated .... "Column name or number of supplied values does not match table definition"
This proc is clearly broker and I don't want to replicate it - but I am not sure which proc it is.
My question is:
When Transactional replication fails, where can I see on which object it failed? I have queried various tables but none from what I can see, pinpoints the exact object (article) name where the failure occurs
any help would be greatly appeciated