.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Transaction (Product Id 54) was dead locked

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
Hi,    I am using sql server 2005 express edition. The database is filled up to 700 MB. it is giving error like "Transaction (Product Id 54) was dead lock resources with another process and had been chosen as dead lock victim returns transaction." I am getting this error for this we are restarting sql server. Then it is working fine for 2 hours after that it is giving same error with diferent product id like 59 etc.   our clients nearly 1000.   I didn't  find what is problem.   Please solve my problem. Because my application in production.     Thanks in Advance.      

View Complete Post

More Related Resource Links

SQL Server Database Transaction

A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

SmtpClient and Locked File Attachments

Got a note a couple of days ago from a client using one of my generic routines that wraps SmtpClient. Apparently whenever a file has been attached to a message and emailed with SmtpClient the file remains locked after the message has been sent. Oddly this particular issue hasn't cropped up before for me although these routines are in use in a number of applications I've built.

Default page for my Forlder(product)?


Hai all,

         I need to show the URL like this http://www.saffronrouge.com/face/moisturizers

for me  http://www.mysite.com/products/

i need to list all the products. please help me on this.

Multiple web methods in one transaction


Hi everyone

Sorry I am kinda new in web services, so it may sound a bit newbish question.

We have a web service that comunicates with the database and exposes web methods that enables the application to access the database. Each method does only one operation (Insert, Update or Delete). What I need to do is create a transaction that will be consisted of multiple calls to the database, meaning multiple calls of more then one web methods. Can I do that? (I read that if the web method does not throw exception - or ContextUtil.SetAbort() is not called - the transaction will be commited automatically when the web method finishes executing, which I don't want to happen because I want to call another web method in the same transaction, and then manually commit the transaction)

Thank you in advance.

Use The Source, Luke: Source Server Helps You Kill Bugs Dead In Visual Studio 2005


The latest releases of WinDBG and Visual Studio know exactly how to use source server, so its benefits are available to both .NET and native C++ developers. See why this is so important in tracking down bugs.

John Robbins

MSDN Magazine August 2006

Web Services: Capturing and Analyzing Client Transaction Metrics for .NET-Based Web Services


This article presents a general-purpose client quality reporting mechanism that can be used in any .NET-based transaction system that employs HTTP/SOAP. The design uses client response time and quality recording, upload of logs as SOAP headers attached to new transaction requests, and server handoff of these headers to a low priority queue for logging and analysis. This technique gives an enterprise near real-time information on actual end-user response times. These response times reflect network delays, client application overhead and server delays. By using this technique, enterprises can avoid the need to develop custom software to mine HTTP logs.

Brian Connolly

MSDN Magazine July 2004

Documents becoming "locked for editing" by self, when no other edits are happening


On our SharePoint 2007 SP1 farm, intermittently, when a user opens a Microsoft Office document (usually Excel) for editing by single-clicking its name in IE, the following error dialog mysteriously occurs when Office opens:

File in Use
myfile.xlsm is locked for editing
by 'domainname\yourname'
Open 'Read-Only' or click 'Notify' to open read-only and receive notification
when the document is no longer in use.

The problem is, nobody else is editing this document, and the identified user ('domainname\yourname') is the name of the current user (the person opening the document right now)!

This is not "user error", e.g., the same user editing the file from two different computers, or the file being checked out. This is a real, intermittent problem. If the same user opens the same file again 1 minute later, the problem might be gone, even though nothing changed.

It's almost as if some kind of intermittent race condition is happening, where the document gets locked too early...?

We are completely stumped. Any ideas?

Other details:
- SharePoint servers (1 front-end, 1 query, 1 indexing) are all Windows 2003 Server
- SQL Server 2008 on database server
- Clients are mostly Windows XP
- Our versioning model is:
--- Content approval: not required

SharePoint Workspace 2010 Product Guide

Get an overview of what's new in SharePoint Workspace 2010 and a deeper look at benefits across all Office 2010 programs, as well as Office Web Apps and Office Mobile 2010.

Programmatic access to Assembly Version in Product Properties?

Using VS2008 and would like to get programmatic access to the Assembly Version property in my Project Properties but I can't seem to find a way to do this. Any suggestions? The project is a .dll and I want to expose this version information to the caller in my interface section as a string.

SSIS Package Transaction locks entire table

Hello, I have SSIS package that using transactions and working as expected. But this locks all the tables involved in the data flow that are get inserted/loaded. If I query those tables during package execution the query waits till SSIS releases the lock. But I can still query those tables using NOLOCK hint. Is this possible SSIS will lock only the rows that it insert/update/delete etc? So that other user can still use that table or another instance of same SSIS Package can load data into those tables? My Package: In the package level I have TransactionOption = Required. The Sequence (Data Flow is inside this sequence) TransactionOption = Supported. I had some issue in my package that I posted here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dfb5a8b9-d43c-452b-bb21-d6aea192fc97 and also resolved. Now I descovered this issue and trying to resolve. Thanks, Prabhat

Find individual customers how have not ordered a product

I need to find any and all customers who have not ordered a product or products. For example, If I have 5 products, I need to know who did not order which products? I have 2 tables: OG table with fields: Line #, Prod Nbr, Desc and Price and Orders table with fields CustName, Cust#, Prod Nbr QtyShipped I am not an SQL expert. Thank you very much for any help you can provide.

CLR Trigger with stored procedures - transaction error

Hi, I've developed sample CLR trigger which call stored procedure but if execution of stored procedure fail I got following exception The context transaction which was active before entering user defined routine, trigger or aggregate "CskTest" has been ended inside of it, which is not allowed. Change application logic to enforce strict transaction nesting. The statement has been terminated.  My trigger [SqlTrigger(Event = "FOR INSERT", Name = "CskTest", Target = "Requirement")] public static void HandleRequirement() { using ( SqlConnection conn = new SqlConnection("Context Connection=true") ) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Test"; conn.Open(); try { cmd.ExecuteNonQuery(); } catch ( Exception ex ) { SqlContext.Pipe.Send(ex.Message); } } } I wanna handle this exception in my catch block. How can I do this?

Dead SQL server

Hi folks An SQL server at work is pretty much dead but I can still access the location where the mdb and ldf files are, so I'm making a copy of them quickly before the server dies completely.  I was wondering what I can do with them though once I have copied with them.  If I build a new SQL server, then can I import these files somehow?  Thanks!

WF4 for High Volume Transaction Apps

Hi! I am in the middle of redesigning my application and I would like to consider WF4 as the center piece for my application logic. My application is an sms gateway service and it can reach up to millions of hits within a short period of time. I would like to know whether WF4 is suitable to be used for millions of hits type of application. Thank You :) Best Regards, Serena

create a product webservie for integration

Hi ! I don't know what I am going to do about it. We are selling productcs on our website and one of our partners wants us to give them a xml integration so that they could sell our products on their websites. So what should we do here? where should we start?we use sql server for my data storage. we have created xml files for fundamentals of a sale page for my products we entegrated the xml file to a sales agent website they will use them to view products, their prices.   everything is clear until here. But on the purchase process I need to write the purchase datas into my database table. I have created a dll assembly to write the data to my database but I had to write the connection string of the database inside the dll. So I don't thing it is the best way to do an operation like that.    Experts ! what is the best way to do that? What can I do here? in the real world, what is the comman way of it ? thanks in advance !
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend