What does “exec sp_reset_connection” mean in Sql Server Profiler? [duplicate]
Like the other answers said, sp_reset_connection indicates that connection pool is being reused. Be aware of one particular consequence! Jimmy Mays’ MSDN Blog said: sp_reset_connection does NOT reset the transaction isolation level to the server default from the previous connection’s setting. UPDATE: Starting with SQL 2014, for client drivers with TDS version 7.3 or higher, … Read more