Deadlock Number 1205

[Former Member]

I use SAP B1 2005A PL 43, MS SQL 2000 and add a module that is made with VB 6. When the transaction is why the following error appears:

Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Please solution on this issue.

Regards,

Agung

[Former Member]

Agung, can you post or describe the SQL that your VB module is using? The note referenced by Kishore may give you a solution but knowing what the module is trying to do may be useful.

[Former Member]

Hi,

Please go through the below note which may find helpful in trouble shooting.

Note 565710 - SQL Server: Database error 1205 (deadlock)

--Kishore