There should be something wrong with the database. You can repair the data. Please ask me to show it to you.

After the list, an error is reported: "The transaction (process ID53) and another process have been deadLOCKed on the lock resource, and this transaction has been selected as the deadlock victim. Please rerun this transaction."?

Answer

This error is usually reported because the database is damaged. dbcc checkdb(issfoodv5) can be used to check whether the database is damaged under the query analyzer. If there is an error message, please download the database repair method to repair it.

during the normal use of the front desk, an error prompt suddenly appears, and the transaction is cancelled. The prompt is as follows:

Error message

1215: The transaction (process ID52) and another process have been deadlocked on the lock resource, and the transaction has been selected as the deadlock victim. Please rerun the transaction.

Answer

For the deadlock problem, there is something in sql that can view the process (note: it is different from the resource manager under windows, so don't confuse it). You can view the current thread status, just close the process that caused the deadlock. If the above situation occurs frequently, it means that there is a loophole in the sql installer. Please retype the sp4 patch package or reinstall SQL.