Microsoft KB Archive/179023

= FIX: T-SQL Debugger Hangs When User Has No Execute Permission =

Article ID: 179023

Article Last Modified on 1/8/2003

-

APPLIES TO


 * Microsoft Visual Basic 5.0 Enterprise Edition

-



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.

Additional query words: sqlserver kbdse kbDSupport kbVBp kbVBp500bug kbVS97SP3fix

Keywords: kbbug kbfix KB179023

-

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

© Microsoft Corporation. All rights reserved.