sp_reset_connection | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


Hi all, Greetings!! Could anyone detail me abt sp_reset_connection. Rajendar ok
The sp_reset_connection stored procedure is used by SQL Server to support remote stored procedure calls in a transaction. And its an undocumented stored procedure used internally by SQL Server. It generally shows up when using connection pooling and it is called by SQL Server to reset the connection options/settings before reusing the connection in the connection pool so that the settings don’t persist to another client connection. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.