D Dmitry Karneyev Oct 22, 2003 #1 Why does ADO.NET use "exec sp_reset_connection" before executing every statement? And what does sp_reset_connection do?
Why does ADO.NET use "exec sp_reset_connection" before executing every statement? And what does sp_reset_connection do?
N Nicholas Paldino [.NET/C# MVP] Oct 22, 2003 #2 Dmitry, The sp_reset_connection stored procedure is used to reset a connection so that when it is used in a pool, nothing from a previous session is stored that is connection-specific. Hope this helps.
Dmitry, The sp_reset_connection stored procedure is used to reset a connection so that when it is used in a pool, nothing from a previous session is stored that is connection-specific. Hope this helps.
