title: SQL Query to return Remote Access Configuration
body: <p>I'm trying to develop a script that will query a SQL DB and its instances to see if remote access is enabled. I can find lots of information on how to manually do this through the SQL Management Console and commands on how to alter the access, but my search is coming up empty on how to just confirm the current state of the config via sql query. Does anyone know how this would be achieved?</p>
  
  <p>Below commands will allow you to configure the relevant sections to allow or disallow various remote sql connections. I'd like to know how to query the current state of each config itme.</p>
  
  <pre><code>exec sp_configure "remote access", &lt;0 or 1&gt; 
  exec sp_configure "remote query timeout", &lt;number of seconds&gt; 
  exec sp_configure "remote proc trans", &lt;0 or 1&gt; 
  </code></pre>