BUG: GPF When Expanding Stored Procedure Icon in SEM

• Microsoft SQL Server, versions 6.0 and 6.5

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

   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.

   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.