I have a SQL 2008 server in a data center. I have a table that has bi-directional transactional replication set up on it to/from several remote sites. Replication TO & FROM the remote sites was done via a script. I have made a schema
change & am now receiving the error
'DDL replication failed to refresh custom procedures, please run "exec sp_register_custom_scripting 'CUSTOM_SCRIPT', your_script, 'ERM from 99', 'REQUESTNEWEMP' "and try again (Source: MSSQLServer, Error number: 21814)'
NOTE - the schema change was made at the main office & it replicated to the data center without issue. The problem is replicating from the data center to the remote locations.
View Complete Post