I understand that a deadlock happens when two processes have locks on data
and each of the processes is waiting for the other to finish. How do I
make change it so the consolidation isn't picked as the deadlock victom?
I am running MS SQL Server 6.5 with SP4 on NT 4.0 SP3.
Thanks!
Greg Dobinson.