June 4, 2007 at 7:07 am
Good morning. I ran into a situation on Friday where a developer kept losing his VPN connection, which happens quite often, while testing a web application (ASP.NET). He happened to be running a fairly long-running query in the web app, and eventually the server got gnarled up (killing the SPID fixed the issue).
This morning while we were talking I had a thought that I would like to get confirmation on. Could the server get confused when a query is executed and the process that executed it is no longer available to issue a return code to? Thanks for your assistance.
June 4, 2007 at 1:11 pm
It could. However, if the connection is killed, it could also be killing the transaction which would also cause a rollback.
-SQLBill
June 4, 2007 at 1:17 pm
OK-thanks for the reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply