Friday, July 11, 2008

Transaction Deadlock Error

I created a query which was used by a SSRS Report. While running the report I got the following error:

"Transaction
(Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim"

I resolved the error by writing the following statement in my stored procedure

"
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"

This statement set the nolock on each table/view used in the query

No comments: