Click here to Skip to main content
12,886,892 members (36,242 online)
   

Database

 
AnswerRe: Maximum number of concurrent connections to SQL Server 2008 Pin
jschell10-Jan-13 14:23
memberjschell10-Jan-13 14:23 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 Pin
Danzy8311-Jan-13 2:59
memberDanzy8311-Jan-13 2:59 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 Pin
PIEBALDconsult11-Jan-13 3:17
memberPIEBALDconsult11-Jan-13 3:17 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 Pin
jschell11-Jan-13 6:18
memberjschell11-Jan-13 6:18 
QuestionSQL Storedprocedure trace other than profiler Pin
Member 31370789-Jan-13 20:19
memberMember 31370789-Jan-13 20:19 
AnswerRe: SQL Storedprocedure trace other than profiler Pin
Sandeep Mewara9-Jan-13 21:22
mvpSandeep Mewara9-Jan-13 21:22 
AnswerRe: SQL Storedprocedure trace other than profiler Pin
Mycroft Holmes9-Jan-13 21:29
memberMycroft Holmes9-Jan-13 21:29 
QuestionZombie check on Transaction - How to reproduce it? Pin
Member 31370787-Jan-13 22:32
memberMember 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? Pin
Jassim Rahma7-Jan-13 4:56
memberJassim Rahma7-Jan-13 4:56 
AnswerRe: Cassandra or MySQL? Pin
Mycroft Holmes7-Jan-13 12:01
memberMycroft Holmes7-Jan-13 12:01 
AnswerRe: Cassandra or MySQL? Pin
PIEBALDconsult7-Jan-13 12:53
memberPIEBALDconsult7-Jan-13 12:53 
QuestionOracle Application expres Pin
Fred Andres6-Jan-13 11:52
memberFred Andres6-Jan-13 11:52 
AnswerRe: Oracle Application expres Pin
Chris Meech6-Jan-13 13:57
memberChris Meech6-Jan-13 13:57 
GeneralRe: Oracle Application expres Pin
Fred Andres7-Jan-13 8:32
memberFred Andres7-Jan-13 8:32 
AnswerRe: Oracle Application expres Pin
Shameel7-Jan-13 3:45
memberShameel7-Jan-13 3:45 
GeneralRe: Oracle Application expres Pin
Fred Andres7-Jan-13 8:32
memberFred Andres7-Jan-13 8:32 
QuestionSQL paging with search Pin
Lance Parker6-Jan-13 2:11
memberLance Parker6-Jan-13 2:11 
AnswerRe: SQL paging with search Pin
jschell6-Jan-13 5:19
memberjschell6-Jan-13 5:19 
GeneralRe: SQL paging with search Pin
Lance Parker7-Jan-13 8:23
memberLance Parker7-Jan-13 8:23 
GeneralRe: SQL paging with search Pin
jschell7-Jan-13 9:12
memberjschell7-Jan-13 9:12 
QuestionI want to ask query related to mysql Pin
manisharathore5-Jan-13 7:32
membermanisharathore5-Jan-13 7:32 
AnswerRe: I want to ask query related to mysql Pin
Mycroft Holmes5-Jan-13 11:03
memberMycroft Holmes5-Jan-13 11:03 
Questionproblem in ado.net with access 2010 Pin
Achilles843-Jan-13 23:20
memberAchilles843-Jan-13 23:20 
AnswerRe: problem in ado.net with access 2010 Pin
Mycroft Holmes4-Jan-13 13:55
memberMycroft Holmes4-Jan-13 13:55 
Questionhow to cast real data type in sql server 2005 Pin
Auf Klarung2-Jan-13 22:55
memberAuf Klarung2-Jan-13 22:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web01 | 2.8.170424.1 | Last Updated 24 Apr 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid