title: What does "exec sp_reset_connection" mean in Sql Server Profiler?
body: <p>Trying to understand what Sql Profiler means by emitting "sp_reset_connection".</p>
  
  <p>I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed,</p>
  
  <pre><code>RPC:Completed       exec sp_reset_connection
  SQL:BatchStarting   SELECT [c].[TestID] AS [TestID], [c].[Description] AS [Description] FROM [dbo].[Test] AS [c]
  SQL:BatchCompleted  SELECT [c].[TestID] AS [TestID], [c].[Description] AS [Description] FROM [dbo].[Test] AS [c]    
  </code></pre>
  
  <p>Basically does first line "exec sp_reset_connection" mean the whole process (my connection was opened, the select stmt is run, then the connection is closed and released back to pool) just take place?  Or my connection is still in open stage.</p>
  
  <p>And, why does the sp_reset_connection executed before my own select statement, shouldn't it the reset come after user's sql?</p>
  
  <p>I'm trying to know is there a way to know in more detail when a connection is opened and closed?</p>
  
  <p>By seeing "exec sp_reset_connection", does that mean my connection is closed?</p>