We have been presenting an issue randomly since we changed our replication to use custom stored procedures for replication.
We have several offices which replicate to our central datacenter, each of this offices have different data corresponding only to their site and we centralize the data from all databases in only one database.
We use custom stored procedures for some tables only for the insert method, but randomly the update method of that table drops and I have to create again. We have been set the replication by using the 'replication support only' method so it only creates
the replications sp. All our articles have the create update, insert and delete stored procedures for replication.
We have done traces for this and the replications is generating the drop but it doesn't recreate the procedure. It only occurs for the articles with custom procs for insert.
The snapshot jobs for each office are disabled.
View Complete Post