Click here to Skip to main content
       

Database

 
JokeRe: SQL Query For String Searching PinmvpEddy Vluggen11-Jan-13 17:18 
QuestionMaximum number of concurrent connections to SQL Server 2008 PinmemberDanzy8310-Jan-13 1:21 
AnswerRe: Maximum number of concurrent connections to SQL Server 2008 PinmemberDavid Mujica10-Jan-13 2:56 
AnswerRe: Maximum number of concurrent connections to SQL Server 2008 PinmemberPIEBALDconsult10-Jan-13 3:03 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 PinmemberMycroft Holmes10-Jan-13 11:47 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 PinmemberPIEBALDconsult10-Jan-13 13:52 
AnswerRe: Maximum number of concurrent connections to SQL Server 2008 Pinmemberjschell10-Jan-13 14:23 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 PinmemberDanzy8311-Jan-13 2:59 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 PinmemberPIEBALDconsult11-Jan-13 3:17 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 Pinmemberjschell11-Jan-13 6:18 
QuestionSQL Storedprocedure trace other than profiler PinmemberMember 31370789-Jan-13 20:19 
AnswerRe: SQL Storedprocedure trace other than profiler PinmvpSandeep Mewara9-Jan-13 21:22 
AnswerRe: SQL Storedprocedure trace other than profiler PinmemberMycroft Holmes9-Jan-13 21:29 
QuestionZombie check on Transaction - How to reproduce it? PinmemberMember 31370787-Jan-13 22:32 
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.
QuestionCassandra or MySQL? PinmemberJassim Rahma7-Jan-13 4:56 
AnswerRe: Cassandra or MySQL? PinmemberMycroft Holmes7-Jan-13 12:01 
AnswerRe: Cassandra or MySQL? PinmemberPIEBALDconsult7-Jan-13 12:53 
QuestionOracle Application expres PinmemberFred Andres6-Jan-13 11:52 
AnswerRe: Oracle Application expres PinmemberChris Meech6-Jan-13 13:57 
GeneralRe: Oracle Application expres PinmemberFred Andres7-Jan-13 8:32 
AnswerRe: Oracle Application expres PinmemberShameel7-Jan-13 3:45 
GeneralRe: Oracle Application expres PinmemberFred Andres7-Jan-13 8:32 
QuestionSQL paging with search PinmemberLance Parker6-Jan-13 2:11 
AnswerRe: SQL paging with search Pinmemberjschell6-Jan-13 5:19 
GeneralRe: SQL paging with search PinmemberLance Parker7-Jan-13 8:23 
GeneralRe: SQL paging with search Pinmemberjschell7-Jan-13 9:12 
QuestionI want to ask query related to mysql Pinmembermanisharathore5-Jan-13 7:32 
AnswerRe: I want to ask query related to mysql PinmemberMycroft Holmes5-Jan-13 11:03 
Questionproblem in ado.net with access 2010 PinmemberAchilles843-Jan-13 23:20 
AnswerRe: problem in ado.net with access 2010 PinmemberMycroft Holmes4-Jan-13 13:55 
Questionhow to cast real data type in sql server 2005 PinmemberAuf Klarung2-Jan-13 22:55 
QuestionRe: how to cast real data type in sql server 2005 PinmemberEddy Vluggen4-Jan-13 22:52 
QuestionSql server like clause Pinmemberrubonkumar28-Dec-12 4:44 
AnswerRe: Sql server like clause PinmvpRichard MacCutchan28-Dec-12 6:05 
AnswerRe: Sql server like clause [modified] PinmemberPIEBALDconsult28-Dec-12 6:38 
GeneralRe: Sql server like clause PinmemberMike Meinz28-Dec-12 6:49 
GeneralRe: Sql server like clause Pinmemberrubonkumar28-Dec-12 19:08 
AnswerRe: Sql server like clause Pinmemberrajarao3044-Jan-13 0:50 
QuestionDatabase design question PinmemberDavidCrow27-Dec-12 15:22 
AnswerRe: Database design question PinmemberPIEBALDconsult27-Dec-12 15:52 
AnswerRe: Database design question Pinmemberjschell28-Dec-12 10:16 
GeneralRe: Database design question PinmemberPIEBALDconsult28-Dec-12 14:42 
GeneralRe: Database design question Pinmemberjschell30-Dec-12 8:28 
AnswerRe: Database design question PinmemberMycroft Holmes28-Dec-12 11:05 
QuestionImporting of Huge fixed width text file in sql server table Pinmemberibrahim sharief27-Dec-12 9:24 
AnswerRe: Importing of Huge fixed width text file in sql server table PinmemberPIEBALDconsult27-Dec-12 14:08 
AnswerRe: Importing of Huge fixed width text file in sql server table PinmemberDeepak Kr130-Dec-12 20:29 
AnswerRe: Importing of Huge fixed width text file in sql server table Pinmemberjschell31-Dec-12 9:14 
Questionshow Sum(Balance) as ob on Rows Header and add next rows balance in ob Pinmemberhadeed147227-Dec-12 6:52 
AnswerRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pinmemberdjj5527-Dec-12 7:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.140905.1 | Last Updated 15 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid