Hi,

I need help, in my application I open one session with nhibernate and use this session for all queries, when my application finish on ms sql server stays sleeping process. After 10 lunches of my application there are 10 sleeping process on server. What should I do on end of application or on end of each query for not leaving sleep process on server??

Thanks for all help

Greetings
Pawel

Are you calling Session.Dispose() before you exit? The connections will probably die eventually when the server times them out, but calling Dispose (or Close) should explicitly close them.