Queries to build START and STOP commands for PUSH Distribution Agents

I had need other day to STOP and START all Distribution Push Agent.  Using the syssubscriptions and syspublications I can easily build list of SQL commands to either stop or start all the Distribution Push Agents.  With output to text, I can copy and execute from SQL Agent Job, or directly in SQL Management Studio
Read More »