title: SQL server equivalent of MySQL's "SHOW VARIABLES"
body: <p>I need to retrieve some information from a SQL Server database. </p>
  
  <p>For example, I'd like the number of authorized, the number of queries connections or others... </p>
  
  <p>With a MySQL database, I can have it with this query: </p>
  
  <pre><code>SHOW VARIABLES;
  </code></pre>
  
  <p>This returns me a result like: </p>
  
  <p><img src="https://i.stack.imgur.com/OoaEQ.png" alt="enter image description here"></p>
  
  <p>Is there an equivalent for SQL Server?</p>