Click here to Skip to main content
11,639,765 members (66,117 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# .NET SQL-Server-2008
I get SqlTransaction.Zombie exception in production(In .NET Windows application not ASP.NET application). I got answer in below article how and when the exception is thrown. In production one server application available which perform DB operation and there could be more than one client applications to interact with server.

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

In the article, it is given that connection is explicitly closed. My question is in real world application what are the possibilities to close the connection (in few cases only it occurs in production)? I would like to hear the possible scenarios to reproduce it.

One of the servers is getting stopped due to the Exception. Please do help.

Is there possibility for SPs to close the connection unexpectedly? If so, please do describe. Thanks in advance.
Posted 6-Jan-13 21:38pm
Comments
Mycroft Holmes at 8-Jan-13 3:49am
   
Rather than a quick answer you should probably put this into the database discussion area you may get a better response.
Member 3137078 at 8-Jan-13 4:34am
   
Thanks for your suggestion. I've placed my question there.

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

  Print Answers RSS
0 Suvendu Shekhar Giri 330
1 CPallini 177
2 F-ES Sitecore 170
3 himanshu agarwal 167
4 Sergey Alexandrovich Kryukov 159
0 OriginalGriff 9,081
1 Sergey Alexandrovich Kryukov 8,847
2 Mika Wendelius 7,027
3 Suvendu Shekhar Giri 2,650
4 F-ES Sitecore 2,558


Advertise | Privacy | Mobile
Web03 | 2.8.150731.1 | Last Updated 7 Jan 2013
Copyright © CodeProject, 1999-2015
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