• I think I've got this... I'd have to disable all 70 Log Reader Agents... and then turn on just the ones that were previously disabled. Sounds like a real pain. I'll look into writing a script for that (I know... system table modification) and it may be good fodder for an article.

    In the mean time, I've modified my "delete crawler" script to limit deletes to batches of 40k rows... it'll take about 35 hours to run in the highly replicated environment, but that's what weekend runs are for. 😛

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)