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
Friday, July 11, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment