Click here to Skip to main content
11,484,402 members (66,790 online)
   

Database

 
JokeRe: SQL Query For String Searching Pin
Eddy Vluggen11-Jan-13 18:18
mvpEddy Vluggen11-Jan-13 18:18 
QuestionMaximum number of concurrent connections to SQL Server 2008 Pin
Danzy8310-Jan-13 2:21
memberDanzy8310-Jan-13 2:21 
AnswerRe: Maximum number of concurrent connections to SQL Server 2008 Pin
David Mujica10-Jan-13 3:56
memberDavid Mujica10-Jan-13 3:56 
AnswerRe: Maximum number of concurrent connections to SQL Server 2008 Pin
PIEBALDconsult10-Jan-13 4:03
memberPIEBALDconsult10-Jan-13 4:03 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 Pin
Mycroft Holmes10-Jan-13 12:47
memberMycroft Holmes10-Jan-13 12:47 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 Pin
PIEBALDconsult10-Jan-13 14:52
memberPIEBALDconsult10-Jan-13 14:52 
AnswerRe: Maximum number of concurrent connections to SQL Server 2008 Pin
jschell10-Jan-13 15:23
memberjschell10-Jan-13 15:23 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 Pin
Danzy8311-Jan-13 3:59
memberDanzy8311-Jan-13 3:59 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 Pin
PIEBALDconsult11-Jan-13 4:17
memberPIEBALDconsult11-Jan-13 4:17 
GeneralRe: Maximum number of concurrent connections to SQL Server 2008 Pin
jschell11-Jan-13 7:18
memberjschell11-Jan-13 7:18 
QuestionSQL Storedprocedure trace other than profiler Pin
Member 31370789-Jan-13 21:19
memberMember 31370789-Jan-13 21:19 
AnswerRe: SQL Storedprocedure trace other than profiler Pin
Sandeep Mewara9-Jan-13 22:22
mvpSandeep Mewara9-Jan-13 22:22 
AnswerRe: SQL Storedprocedure trace other than profiler Pin
Mycroft Holmes9-Jan-13 22:29
memberMycroft Holmes9-Jan-13 22:29 
QuestionZombie check on Transaction - How to reproduce it? Pin
Member 31370787-Jan-13 23:32
memberMember 31370787-Jan-13 23: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 5:56
memberJassim Rahma7-Jan-13 5:56 
AnswerRe: Cassandra or MySQL? Pin
Mycroft Holmes7-Jan-13 13:01
memberMycroft Holmes7-Jan-13 13:01 
AnswerRe: Cassandra or MySQL? Pin
PIEBALDconsult7-Jan-13 13:53
memberPIEBALDconsult7-Jan-13 13:53 
QuestionOracle Application expres Pin
Fred Andres6-Jan-13 12:52
memberFred Andres6-Jan-13 12:52 
AnswerRe: Oracle Application expres Pin
Chris Meech6-Jan-13 14:57
memberChris Meech6-Jan-13 14:57 
GeneralRe: Oracle Application expres Pin
Fred Andres7-Jan-13 9:32
memberFred Andres7-Jan-13 9:32 
AnswerRe: Oracle Application expres Pin
Shameel7-Jan-13 4:45
memberShameel7-Jan-13 4:45 
GeneralRe: Oracle Application expres Pin
Fred Andres7-Jan-13 9:32
memberFred Andres7-Jan-13 9:32 
QuestionSQL paging with search Pin
Lance Parker6-Jan-13 3:11
memberLance Parker6-Jan-13 3:11 
AnswerRe: SQL paging with search Pin
jschell6-Jan-13 6:19
memberjschell6-Jan-13 6:19 
GeneralRe: SQL paging with search Pin
Lance Parker7-Jan-13 9:23
memberLance Parker7-Jan-13 9:23 
GeneralRe: SQL paging with search Pin
jschell7-Jan-13 10:12
memberjschell7-Jan-13 10:12 
QuestionI want to ask query related to mysql Pin
manisharathore5-Jan-13 8:32
membermanisharathore5-Jan-13 8:32 
AnswerRe: I want to ask query related to mysql Pin
Mycroft Holmes5-Jan-13 12:03
memberMycroft Holmes5-Jan-13 12:03 
Questionproblem in ado.net with access 2010 Pin
Achilles844-Jan-13 0:20
memberAchilles844-Jan-13 0:20 
AnswerRe: problem in ado.net with access 2010 Pin
Mycroft Holmes4-Jan-13 14:55
memberMycroft Holmes4-Jan-13 14:55 
Questionhow to cast real data type in sql server 2005 Pin
Auf Klarung2-Jan-13 23:55
memberAuf Klarung2-Jan-13 23:55 
QuestionRe: how to cast real data type in sql server 2005 Pin
Eddy Vluggen4-Jan-13 23:52
memberEddy Vluggen4-Jan-13 23:52 
QuestionSql server like clause Pin
rubonkumar28-Dec-12 5:44
memberrubonkumar28-Dec-12 5:44 
AnswerRe: Sql server like clause Pin
Richard MacCutchan28-Dec-12 7:05
mvpRichard MacCutchan28-Dec-12 7:05 
AnswerRe: Sql server like clause [modified] Pin
PIEBALDconsult28-Dec-12 7:38
memberPIEBALDconsult28-Dec-12 7:38 
GeneralRe: Sql server like clause Pin
Mike Meinz28-Dec-12 7:49
memberMike Meinz28-Dec-12 7:49 
GeneralRe: Sql server like clause Pin
rubonkumar28-Dec-12 20:08
memberrubonkumar28-Dec-12 20:08 
AnswerRe: Sql server like clause Pin
rajarao3044-Jan-13 1:50
memberrajarao3044-Jan-13 1:50 
QuestionDatabase design question Pin
DavidCrow27-Dec-12 16:22
memberDavidCrow27-Dec-12 16:22 
AnswerRe: Database design question Pin
PIEBALDconsult27-Dec-12 16:52
memberPIEBALDconsult27-Dec-12 16:52 
AnswerRe: Database design question Pin
jschell28-Dec-12 11:16
memberjschell28-Dec-12 11:16 
GeneralRe: Database design question Pin
PIEBALDconsult28-Dec-12 15:42
memberPIEBALDconsult28-Dec-12 15:42 
GeneralRe: Database design question Pin
jschell30-Dec-12 9:28
memberjschell30-Dec-12 9:28 
AnswerRe: Database design question Pin
Mycroft Holmes28-Dec-12 12:05
memberMycroft Holmes28-Dec-12 12:05 
QuestionImporting of Huge fixed width text file in sql server table Pin
ibrahim sharief27-Dec-12 10:24
memberibrahim sharief27-Dec-12 10:24 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
PIEBALDconsult27-Dec-12 15:08
memberPIEBALDconsult27-Dec-12 15:08 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
Deepak Kr130-Dec-12 21:29
memberDeepak Kr130-Dec-12 21:29 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
jschell31-Dec-12 10:14
memberjschell31-Dec-12 10:14 
Questionshow Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
hadeed147227-Dec-12 7:52
memberhadeed147227-Dec-12 7:52 
AnswerRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
djj5527-Dec-12 8:53
memberdjj5527-Dec-12 8: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
Web01 | 2.8.150520.1 | Last Updated 22 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid