sp_reset_connection

  • Thread starter Thread starter Dmitry Karneyev
  • Start date Start date
D

Dmitry Karneyev

Why does ADO.NET use "exec sp_reset_connection" before executing every
statement?
And what does sp_reset_connection do?
 
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.
 
Back
Top