<div>
If you can wait with second report until the first one finishes, thet will be no deadlock. But if you must run these reports simultaneously, you will probably have to redesign your procedures. There's a simple rule - access tables in the same order - tis way you can get locks, but you will probably avoid deadlocks.
</div>


If you can wait with second report until the first one finishes, thet will be no deadlock. But if you must run these reports simultaneously, you will probably have to redesign your procedures. There's a simple rule - access tables in the same order - tis way you can get locks, but you will probably avoid deadlocks.

<div>
Hi, Thanks for the answers<br />
<br />
I am not running the two reports together they are being run seperately, but still lock out individually
</div>


Hi, Thanks for the answers

I am not running the two reports together they are being run seperately, but still lock out individually

<div>
did you tested the nolock option? did it helped or no joy?<br />
<br />
<br />
<br />
<br />

</div>


did you tested the nolock option? did it helped or no joy?






<div>
<div class="content wysiwyg-content">
I developed two stored procedures on Friday for two seperate Crystal Reports, every time I run them I get a message saying that I am deadlock victime, error 4001, failed to open a rowset. This does not happen for any other stored procedures, only 2 I wrote within an hour of each other. Is there any I can do about this or should I delete them and rewrite them?
</div>
</div>


I developed two stored procedures on Friday for two seperate Crystal Reports, every time I run them I get a message saying that I am deadlock victime, error 4001, failed to open a rowset. This does not happen for any other stored procedures, only 2 I wrote within an hour of each other. Is there any I can do about this or should I delete them and rewrite them?

Lock Outs

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.