Shuts down the ASE Replicator process.
sp_shutdownrep [immediate]
is the keyword for shutting down the ASE Replicator process immediately.
sp_shutdownrep immediate
Shuts down the ASE Replicator process immediately, without quiescing the system or flushing any queues.
When you invoke sp_shutdownrep with no keyword, ASE Replicator shuts down gracefully by first emptying its internal queues and completing any current but uncommitted transactions, then suspending all database connections and subscriptions.
When you invoke sp_shutdownrep with the immediate keyword, ASE Replicator rolls back any work in progress and then shuts down.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.
sp_suspendrep