Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# .NET SQL-Server-2008
Hi All,
 
In my .NET application(Windows Application) I get exception SqlTransaction.ZombieCheck. I'm new to the application where I get this exception. Technically in general in which scenario the exception would be thrown? How to resolve the error? If you come across this exception please do share your points with me. Thanks in advance.
Posted 10-Dec-12 2:24am
Edited 10-Dec-12 2:49am
RyanDev110.4K
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi
 
It happens when you try to operate in a transaction which has already been committed or rolled back. The scenario could be observed when the inherent connection that the transaction is using is closed and then you try to commit or rollback the transaction.
 
You may wanna check this blog here http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/08/24/zombie-check-on-transaction-error-this-sqltransaction-has-completed-it-is-no-longer-usable.aspx[^]
 
Regards
Pawan
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 359
1 Richard MacCutchan 320
2 OriginalGriff 240
3 Jared Sanow 145
4 Snehasish_Nandy 115
0 Sergey Alexandrovich Kryukov 5,969
1 OriginalGriff 5,005
2 CPallini 2,473
3 Richard MacCutchan 1,547
4 Abhinav S 1,507


Advertise | Privacy | Mobile
Web01 | 2.8.140814.1 | Last Updated 13 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100