SQL 2008 (Server A) replicates to SQL 2008(Server B) which replicates to SQL 2008(Server C).
I recently added a column (to Server A) to a replicated table SMS & the DDL change replicated to Server B with out a problem. When the DDL change replicated to Server C, I received the error below.
replication failed to refresh custom procedures, please run "exec sp_register_custom_scripting 'CUSTOM_SCRIPT', your_script, 'publication_name_here', 'table_name_here' "and try again (Source: MSSQLServer, Error number
View Complete Post