Knowledge Base

FIX: SELECTs from SYSPROCESSES Result in Access Violation

Article ID: 151985

Article Last Modified on 10/16/2003

Microsoft SQL Server 6.0 Standard Edition
Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q151985

SYMPTOMS

On busy symmetric multiprocessing (SMP) computers, queries against the virtual table sysprocesses may infrequently get a handled access violation, causing the client connection to be terminated. Other clients are unaffected. The call stack of the access violation will look similar to the following:

findwaitfor+0x2f
ins_sysproc+0x7fc
make_fake+0xe8
s_setuptables+0x2bc
s_execute+0x7d8
sequencer+0x23f
execproc+0xfb7
s_execute+0xb8c
sequencer+0x23f
language_exec+0x65e

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: SQL6 SQL65 SP_WHO

Keywords: kbbug kbfix kbnetwork KB151985