How can a deadlock occur that is not triggered by the SQL server?
The SQL server recognizes and removes deadlocks at which SPIDs (SQL server processes) block. In principle, however, lock situations may also occur at a higher application level, in other words between two database applications. This is possible if database applications open several connections to SQL servers and hold, or request, various locks on them. A deadlock could then arise between two of these applications. If the application does not react to this type of lock itself, but instead waits indefinitely, you can only resolve the situation by manually terminating one of the programs. The SQL server cannot recognize or cannot react to this kind of situation since the application program should deal with this. In the ABAP, you can open additional database connections. Therefore, in principle, this means it is possible to cause the deadlock situation described above. As long as the database interface opens several connections to the SQL server by default, the system ensures in the inter
