var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sp_MSupd* Replication Procs Mysteriously Getting Dropped
We have transactional replication (SQL 2000 SP3) and are noticing that certain sp_MSupd type stored procedures are sporadically being dropped from the database for no apparent reason.
Has anyone ever heard of this before?
try creating a profile trace and watch specifically for any drop statements. if this catches it, you should be able to find the source machine which is dropping the sp