kodaksmile
MIS
I have used the following stored proc before (run against the publisher) to generate the custom replication stored procedures that you then run on the subscriber (so inserts, updates and deletes can use a stored proc to perform the changes)
sp_scriptpublicationcustomprocs 'publication name'
However when I run this on one of my publications I get the following message for every object:
Replication custom procedures will not be scripted for article 'abc' because the auto-generate custom procedures schema option is not enabled.
I have never seen this before - anyone know what this means? and how to fix it?
sp_scriptpublicationcustomprocs 'publication name'
However when I run this on one of my publications I get the following message for every object:
Replication custom procedures will not be scripted for article 'abc' because the auto-generate custom procedures schema option is not enabled.
I have never seen this before - anyone know what this means? and how to fix it?