Post reply

sp_reset_connection:1

  • August 7, 2007 at 2:03 am

    #373135

    Can any body tell me the purpose of this undocumnetd xtended storeprocedure

    sp_reset_connection:1

    is it for internal use of SQL server

  • August 9, 2007 at 5:41 am

    #725677

    Applications such as ASP.NET use connection pool. so any website session can send any TSQL query on any of the connections that are pooled.

    To ensure that the current page does not get anything left over from last page/query, this proc is used. This saves overhead of disconnect and re-connect for every query/page hit.

    This proc is used internally by the OLEDB Providers/ODBC drivers.


    -- Amit


    "There is no 'patch' for stupidity."


    Download the Updated SQL Server 2005 Books Online.

  • August 9, 2007 at 6:04 am

    #725685

    ahan Thnx Amit

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply