FIX: T-SQL Debugger Hangs When User Has No Execute Permission (179023)


The information in this article applies to:

  • Microsoft Visual Basic Enterprise Edition for Windows 5.0
This article was previously published under Q179023

SYMPTOMS

When using T-SQL debugger to debug stored procedures from Visual Basic, if a SQL Server login user does not have Execute permission granted to the extended stored procedure sp_sdidebug in Master database, Visual Basic comes to a halt.

CAUSE

The user needs to have rights to execute the extended stored procedure sp_sdidebug. The default access is for sa only.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This bug has been fixed in Visual Studio 97 Service Pack 3.
Modification Type:MinorLast Reviewed:1/8/2003
Keywords:kbbug KB179023
©2002 Microsoft Corporation. All rights reserved.