This has been bugging me for sometime now. I’ve tried to read documentation from Microsoft and it confuses the crap out of me.
What I’m trying to accomplish is when someone creates a new stored procedure, new table etc. I’m needing to have the new table, proc etc. added as an article and the subscription reinitialized.
The current setup uses transactional replication with a central subscriber (4 SQL Servers).