Trying to understand what Sql Profiler means by emitting &quot;sp_reset_connection&quot;.

I have the following, &quot;exec sp_reset_connection&quot; line followed by BatchStarting and Completed,

    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]	

Basically does first line &quot;exec sp_reset_connection&quot; 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.

And, why does the sp_reset_connection executed before my own select statement, shouldn&#39;t it the reset come after user&#39;s sql?

I&#39;m trying to know is there a way to know in more detail when a connection is opened and closed?

By seeing &quot;exec sp_reset_connection&quot;, does that mean my connection is closed?


All Sp Reset-Connection Solutions on Gang of Coders

Total of 1 Sp Reset-Connection Solutions

What does "exec sp_reset_connection" mean in Sql Server Profiler?