Resumes all primary database connections or a specified primary database connection.
sp_resumeprimaryconn [conn_name]
is the name of a primary 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 primary database resides.
db is the name of the primary database.
sp_resumeprimaryconn "boulder.doc"
Resumes the primary connection to the database doc on the data server boulder.
When you invoke sp_resumeprimaryconn without specifying a connection name (conn_name), it resumes all primary database connections.
When you invoke sp_resumeprimaryconn and specify a connection name (conn_name), it resumes the primary 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_helpprimaryconn, sp_suspendprimaryconn
