BUG: GPF When Expanding Stored Procedure Icon in SEM (168084)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2003 |
|---|
| Keywords: | kbBug kbusage KB168084 |
|---|
|