SQL Server Performance Forum – Threads Archive
sp_reset_connection
Hi all, Greetings!! Could anyone detail me abt sp_reset_connection. Rajendar okThe 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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>