In Sybase I can set replicate off/on in a procedure or DDL/DML Change Replication for the Current isql Session for sybase. Is there a similar way in a sql server ?
set replication [on | force_ddl | default | off]
The other linked question mentioned an article of using sp_MSstopdistribution_agent
but I am not able to find it on the database. is it possible i need to have setreplication working ?
As the comment mentioned the linked answer explain how to pause all replication in the server however i am searching for a way to pause the current session only.