Suspends all replicate database connections or a specified replicate database connection.
sp_suspendreplicateconn [conn_name]
is the name of a replicate database connection. The connection name (conn_name) must be specified in the form ds.db, where:
ds is the name of the data server on which the replicate database resides.
db is the name of the replicate database.
sp_suspendreplicateconn "boulder.doc"
Suspends the replicate connection to the database doc on the data server boulder.
When you suspend a replicate database connection with sp_suspendreplicateconn, it suspends all subscriptions associated with that replicate database connection.
When you invoke sp_suspendreplicateconn with no connection name (conn_name) specified, it suspends all replicate connections.
When you invoke sp_suspendreplicateconn and specify a connection name (conn_name), it suspends the replicate connection to the specified database.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.
sp_helpreplicateconn, sp_resumereplicateconn
