spid

  • How can I find out what is spid 222?

    What is this error mean??

    This is my error message:

    The client was unable to reuse a session with SPID 222, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.

    Thank you

  • spid 222 was apparently being used in connection pooling and the app tried to use it again but it was no longer available.

    This article should get you going in the correct direction.

    http://support.microsoft.com/kb/937745

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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