September 20, 2012 at 3:17 am
Hello,
Following runtime-error occurs in vb6 when trying to run a transaction:
"Transaction was deadlocked on lock resources with another process and has been chosen as a deadlock victim"
What does this mean ? This error never appeared before.
Thank you,
Stephan
September 20, 2012 at 4:39 am
Hi
It means that another process is using and locking the table that you are trying to update
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
September 20, 2012 at 7:37 am
It's not just that something else is using the table, that'd just be blocking.
http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/|
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply