BUG: GPF When Expanding Stored Procedure Icon in SEM

ID: Q168084

The information in this article applies to:

Microsoft SQL Server versions 6.0, 6.5

BUG #: 16838

SYMPTOMS

You may receive the following error on Sqlew.exe while expanding the stored procedure icon in the Server Manager of the SQL Enterprise Manager (SEM):

SQLEW.EXE - Application Error
The instruction at "0x10205c1b" referenced memory at "0x00000000".
The memory could not be "read".
Click on OK to terminate the application
Click on CANCEL to debug the application

After you click OK, the following error message appears:

SQLEW.EXE -Application Error
The instruction at "0x5f801167" referenced memory at "0x00000008".
The memory could not be "read".
Click on OK to terminate the application.

The default debugger (typically Dr. Watson) may appear and display the following error:

Application error has occurred and an application error log is being
generated.
SQLEW.EXE Exception access violation 0xc0000005 address 0x1011b1d4.

CAUSE

This problem occurs when a user is deleted directly from the sysusers table that owns stored procedures in the database.

WORKAROUND

To work around this problem, you can manually delete the entries of the stored procedure from both sysobjects and syscomments by finding its object ID. Re-create the stored procedure if necessary, and recycle the SQL Server.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: unhandled exception GPF general protection fault


Keywords          : kbusage SSrvEntMan SSrvGPF kbbug6.50 kbbug6.00 
Version           : 6.0 6.5
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 9, 1999