Article ID: 179023 - View products that this article applies to.
This article was previously published under Q179023
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.
The user needs to have rights to execute the extended stored procedure sp_sdidebug. The default access is for sa only.
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.
Article ID: 179023 - Last Review: January 8, 2003 - Revision: 1.1
Contact us for more help
Connect with Answer Desk for expert help.