title: What does sp_reset_connection do?
body: <p>sp_reset_connection seems to be called by SQL Server connection pooling, to ensure that connections reused from the pool have most of their settings reset. Does anyone know exactly what it does and doesn't do though? </p>
  
  <p>eg I see from <a href="http://blogs.msdn.com/jimmymay/archive/2009/02/02/sp-reset-connection-does-not-reset-transaction-isolation-level-unexpected-behavior-by-design.aspx" rel="noreferrer">this post</a> that it doesn't reset the transaction isolation level</p>