Getting primary connection configuration information

To get configuration parameter information about a primary database connection, use sp_configprimaryconn and specify a database connection:

sp_configprimaryconn "conn_name"

where conn_name is the connection name in the form ds.db.

To get information about a specific configuration parameter in a primary database connection, use sp_configprimaryconn and specify the database connection and the parameter name:

sp_configprimaryconn "conn_name", param

where conn_name is the connection name in the form ds.db, and param is the configuration parameter name.