• This is common question I have seen many times on various newsgroups :).

    But - have you ever used the option - lightweight pooling set to on? There are not many common scenarios when this could be helpful I think.

    Kindest Regards,

    Damian Widera
    SQL Server MVP,
    MCT, MCSE Data Platform, MCSD.NET