title: Difference between Session and Connection in SQL Server
body: <p>In case of temporary tables, we see that they are connection dependent. I mean that tables created in one connection is only available to that connection and automatically dropped when the connection is lost or destroyed.</p>
  <p>What is the difference between connection and session in SQL Server?</p>