The sp_configprimaryconn and sp_configreplicateconn procedures can return information about the connection configuration for primary and replicate database connections.
See “Connection configuration parameters” for information about database connection configuration parameters.