Posted by gjvdkamp on 12/03/05 21:34

Are you sure you're referencing the tables in the same order in your
SP's? If you select from tables in the same order in both SP's they
should not get in eachothers way.

You want to avoid reading from table A and then B in SP1, and first
table B and then A in SP2. WHen they execute at the same moment, they
lock eachothers second tables, and we know what happens then...

If that doent help maybe you can set the isolation level to read
uncommitted if the business logic allows this.

Good luck,

Gert-Jan

• Next in forum: 1 SP with dynamic input parameters and multiple rows as the source of the query
• Prev in forum: Re: Getting data from multiple rows into one column
• Thread view: Re: Help needed by deadlock problem

[Reply to this message]