Hi all,
I have a quick question with regards to how SQL Server (2005) will treat
conncetions that are left open (due to a programmer forgetting to close
them in a .net web app).
I'm basically wondering if they'll just sit their indefinately, or will
SQL Server kill them after a period of inactivity? If it will eventually
kill them off, what is the period of time that it will wait for?
Thanks to anyone who can advise
Simon
Hi there
OK - now what will cause the network layer that the connection is no
more? The application or website being restarted?
Thanks
Simon
Tibor Karaszi wrote:
> SQL Server will kill (first rollback if necessary) the connections when the network layer had
> informed that this is no more.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment