Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    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?


  2. #2
    Join Date
    May 2003
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts