• anthony.green (1/14/2013)


    Could you not re-write the app to use connection pooling instead of spawning a new SPID as and when the app needs it?

    A side question , can we set the timeout limit for any query in sql server itself ? another thing does sql server have any concept like 'connection pooling' or it is managed by app only ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)