• meird

    We did consider such things but with 439 Log Reader Agents and 2445 Distribution Agents and given that we originally delivered this on SQL Server 7 we decided against it. SQL Server 7 was nowhere near as flexible as 2000/2005 and all too often upgrades to our software required subscriptions and publications to be dropped and re-created which would mean having to put back in the job step you describe. Too much of an administrative overhead back then.