Hi Grant Fritchey,

I have edited the post and attached the deadlock graph

The post over http://www.sqlservercentral.com/Forums/Topic621088-145-1.aspx is related to this one.

But I mistook blocking as deadlock. I have resolved the blocking one. But the deadlock is the one I couldn't...

Initially I issue a select statement to read the balance from a table.

Next, I subtract the amount to be transfered

and finally, I update the balance to the same table.

The above...

If I use TABLOCKX instead of ROWLOCK, the applications in both the systems are getting non-responsive and there was no deadlock graph in ERRORLOG too...

Here is the graph from error log..

I have deleted the SQL after the SET keyword for convenience. Those SQLs are different and did not have any Primary Key conflicts..

2008-11-27 16:40:58.64...

Hi Kumar,

Basically I am new to this SQL Server stuff...

I am using MSSQL Server 2005 Express. I turned on trace by using DBCC TRACEON (1024). But in the errorlog, I...