Re: Any way to debug using SQL SP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rick Sawtell (ricksawtell_at_hotmail.com)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 08:40:41 -0700

VS.NET does have a SQL Debugger in it.

>From the VS.NET Help file:
==========================
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

  a.. 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.

Rick Sawtell
MCT, MCSD, MCDBA

Relevant Pages

  • Re: Any way to debug using SQL SP
    ... > VS.NET does have a SQL Debugger in it. ... > To debug a stored procedure from Server Explorer ...
    (microsoft.public.sqlserver.server)
  • Re: SQLdatasource delete with parameter output
    ... Also you can possibly debug and step into your stored procedure. ... @SiteProjectID Int, ... @MeasureID Int, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OPENXML debugging
    ... I am a bit confused re your debug feedback. ... > The code then called the stored procedure - again, ... I did turn on T-SQL debugging when the throw was ... > If the work around is the best practice, can the MSDN article be changed? ...
    (microsoft.public.sqlserver.xml)
  • Re: ERROR 8162
    ... can't help since I am not able to debug it. ... > I not using a Stored Procedure. ... > from within an SQR program. ... >, JOBCODE ...
    (microsoft.public.sqlserver.programming)
  • Re: VS .NET Debugging
    ... Web interface: ... However do not know it anymore, maybe you can search it yourself. ... Start debug and I ... > and of course while the stored procedure does execute and return results, ...
    (microsoft.public.dotnet.languages.vb)