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

This article was previously published under Q179023
This article has been archived. It is offered "as is" and will no longer be updated.
When using T-SQL debugger to debug stored procedures from Visual Basic, ifa SQL Server login user does not have Execute permission granted to theextended stored procedure sp_sdidebug in Master database, Visual Basiccomes to a halt.
The user needs to have rights to execute the extended stored proceduresp_sdidebug. The default access is for sa only.
Microsoft has confirmed this to be a bug in the Microsoft products listedat the beginning of this article. This bug has been fixed in Visual Studio97 Service Pack 3.
sqlserver kbdse kbDSupport kbVBp kbVBp500bug kbVS97SP3fix

Article ID: 179023 - Last Review: 01/06/2015 02:43:29 - Revision: 1.1

  • Microsoft Visual Basic 5.0 Enterprise Edition
  • kbnosurvey kbarchive kbbug kbfix KB179023