SQL Server deadlock on lock resources error

When performing a task on the intranet, such as a force re-sync or any other task, you may encounter an error similar to the following:

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

This error reports that another task on your SQL Server has locked down the same resource that your intranet is attempting to connect to and retrieve information. When this happens, the task fails and you may encounter this error.

Investigating into this lead our team to the following MS KB article talking about updates to a higher Service Pack for SQL Server 2008 R2:


Have more questions? Submit a request


Article is closed for comments.