Re: SQL Deadlock

Dale E. Reed Jr. ( (no email) )
Sun, 05 Jul 1998 16:18:39 -0700

Greg Dobinson wrote:
> In my quest to get the consolidation process to work I have come across
> this error message when doing a consolidation 12 in the ISQL_w utility.
> SQL has detected a deadlock. Your connection has been chosen as the
> deadlock victom.(not quite exactly of course).
> 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.

AFAIK, you can't. I'd be curious as to what could be contending with
it for a lock, though. What else is running?

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |