Asked By Stephen Atkins
17-Nov-09 05:46 PM
Hello everyone. I've got a bunch of tables that we are replicating to about 10 other servers. Some are constantly connected others only periodically. Because of this I really do not want to break replication and recreate it.
Whats happened is someone (who's no longer here) deleted the insert, update, and delete triggers from our publisher for one of our tables. Because of this non of the rows that are in this table are replicating any more.
Does any one know how I can get these triggers back with out remaking the publication? This is on the publisher. All of the subscribers have their triggers and are sending data back to the publisher just fine.
Thanks for your help.
Stephen