Pause Replication: Publication to Subscriber

--TO Pause Replication from Publication to Subscriber

--EX: if i want to Pause Replication from
  --4 to  01
  --5 to  01


SELECT @@SERVERNAME


exec distribution.dbo.sp_MSstopdistribution_agent
@publisher  = '4',
@publisher_db   = 'TEST',-
@publication    = 'TEST_Pub',--publisher names
@subscriber     = '1',
@subscriber_db  = 'TEST'



---to Start Again
exec distribution.dbo.sp_MSstartdistribution_agent
@publisher  = '4',
@publisher_db   = 'TEST',
@publication    = 'TEST_Pub',
@subscriber     = '1',
@subscriber_db  = 'TEST'



--TO pause Publication: not replicating TO Any Subscriber
--just right click on Replication Publication ,
--View Log reader agtent status
--LOG reader agent and STOP