Export (0) Print
Expand All
2 out of 6 rated this helpful - Rate this topic

Debugging SQL Stored Procedures

Visual Studio .NET 2003

In Visual Studio, you can debug a stored procedure from Server Explorer or a source window.

To debug a stored procedure from Server Explorer

  1. Establish a connection to a database using Server Explorer. For more information, see Server Explorer Window.
  2. Expand the <database name> node.
  3. Expand the Stored Procedures node.
  4. Right-click the stored procedure you want to debug and choose Step Into Stored Procedure from the shortcut menu.

To debug a stored procedure in the text editor

  • In a source window, right-click the stored procedure and choose Step Into Stored Procedure from the shortcut menu.

For more information, see Enabling SQL Debugging on SQL 2000 Desktop Engines.

Visual Studio also enables you to debug extended stored procedures. However, you cannot debug SQL statements that are executed outside of a stored procedure.

See Also

Debugging SQL | System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.