Microsoft KB Archive/168084

= BUG: GPF When Expanding Stored Procedure Icon in SEM =

Article ID: 168084

Article Last Modified on 10/16/2003

-

APPLIES TO


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

-



This article was previously published under Q168084



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: kbbug kbusage KB168084

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.