BUG: Expanding Stored Procedures in Data View Window Causes GPF

• Microsoft Visual Studio 6.0
• Microsoft Visual InterDev, version 6.0
• Microsoft Visual J++, version 6.0
• Microsoft SQL Server version 6.5
• Microsoft Visual Basic Learning, Professional, and Enterprise Editions for Windows, version 6.0

SYMPTOMS

Clicking the plus sign to expand a stored procedure in the Data View window in either Visual Basic, Visual InterDev, or Visual J++ generates the following error message if the stored procedure contains calls to extended stored procedures that return something other than 0 or 1, such as xp_cmdshell:

Devenv.exe - Application Error The instruction at "0x412406f3" referenced memory at "0x00000006". The memory could not be "read".

CAUSE

Clicking the plus sign executes the stored procedure to enumerate the parameters and tables for the stored procedure. When the data environment tries to execute xp_cmdshell it generates an error.

RESOLUTION

This problem does not occur with SQL Server 7.0.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

1. Open a Visual InterDev project that connects to a SQL Server 6.5 database.



2. Create a new stored procedure with the following command:
   

   
   EXEC Master..xp_cmdshell 'dir *.exe' 




3. Save the stored procedure.



4. Click on the plus sign by the stored procedure to view its parameters and tables.

Additional query words:

Keywords : kbStoredProc kbVBp600bug kbVisID600bug kbVJ600bug
Version : WINDOWS:6.0; winnt:6.5
Platform : WINDOWS winnt
Issue type : kbbug