title: Should I always use connection.close
body: <ol>
  <li><p>Should I always close my db connection or is it closed automatically?</p></li>
  <li><p>What happens if I don't close it?</p></li>
  <li><p>Is it somehow possible to close the connection in the case of asp error? I don't want to use "on error goto next" -command but stop the script if an error occurs.</p></li>
  <li><p>How does the automatic closing differ between SQL Server 2008 and 2012?</p></li>
  </ol>