sql server programming: Hi,

I have a VB .NET Application accessing a SQL Server 2000. This application
uses stored procedures extensively to access the data. My question concerns
the processes on the server. I've been observing 15 - 30 sleeping processes
running just after starting my application. Many of these are due to my
stored procedures. Should I be seeing this just from opening my
application? I've been closing my connections after executing any data
access code, as well as closing my objects. Any suggestions or comments
would be appreciated regarding this.

Thankyou,

Jeff Haumesser

[quoted text, click to view]

As long as you are correctly closing AND disposing of your objects when
you are done with them you will be fine. The default nature of
connection pooling will keep the connections open for a while until they
haven't been used for a while and then close the connection.

If you are just closing the objects when you are done with them you
"should" be ok, but it is usually a best practice to always Dispose when
an object implements IDisposable.

--
Aaron Weiker
http://aaronweiker.com/