Article ID: 156096 - View products that this article applies to.
This article was previously published under Q156096
This article has been archived. It is offered "as is" and will no longer be updated.
With Visual C/C++ 4.2 Enterprise Edition or later you can debug SQL Server stored procedures and triggers. This article contains a list of assorted tips that might help with debugging. At the end of the article, there is an excerpt from the Readme.txt file.
SQL Server Debugging must be enabled. To enable SQL Server debugging, check the SQL Server Debugging check box on the SQL tab of the Options dialog box. The Options dialog box is available by choosing the Options command on the Tools menu. If using VC++ 5.0 or 6.0 the tab is "Data View" instead of SQL.
The Remote Connection must be set to Local, not to TCP/IP or to Serial. To set the Remote Connection, choose the Remote Connection command on the Tools menu.
The current project must be of type x86 (not Macintosh). To set the current project type, choose the Configurations command from the Build menu.
The stored procedure must be stored on SQL Server version 6.5 or later.