By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,480 Members | 1,144 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,480 IT Pros & Developers. It's quick & easy.

Rollback transaction after connection lost

P: n/a
Hi,
I have a problem. When my computer loses connection to
server during transaction it is rolled back automaticly
by server after 2-5 minutes. During the time a can reset
my computer, run my program again and I can see
data from not commited transaction becouse I have to
set isolation level to read uncommited.
How to force the server immediately rollback transaction?

TIA
clint

Feb 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
(dj) writes:
I have a problem. When my computer loses connection to
server during transaction it is rolled back automaticly
by server after 2-5 minutes. During the time a can reset
my computer, run my program again and I can see
data from not commited transaction becouse I have to
set isolation level to read uncommited.
How to force the server immediately rollback transaction?


Apparently SQL Server does not sense that the client is gone. I will have
to admit that I don't know how that works. I would sort of expect that
if you pull the plug, SQL Server would be notified directly, but net-
working is not my best subject.

Anyway, if you can do sp_who and identify your process, you can use the
KILL command to stop the process directly. You need sysadmin privileges
to use KILL.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Feb 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.