You can set or change certain configuration parameters for each database connection.
For more information about connection configuration parameters for primary and replicate databases, see “Connection configuration parameters”.
To configure a primary database connection
Use sp_configprimaryconn with the following syntax:
sp_configprimaryconn "conn_name", param, value
where conn_name is the connection name in the form ds.db, param is the name of the configuration parameter, and value is the value of the configuration parameter.
To configure a replicate database connection
Use sp_configreplicateconn with the following syntax:
sp_configreplicateconn "conn_name", param, value
where conn_name is the connection name in the form ds.db, param is the name of the configuration parameter, and value is the value of the configuration parameter.
