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.