How to debug -- sql server programming

zwieback89 via SQLMonster.com
1/12/2007 11:10:13 PM

Hi,

Any ideas as to how I can debug a stored procedure?

This stored procedure has no parameters.

It grabs data from a base table, dumps the data into a Tree table, then it
builds a Stack table to build the Org Structure.

I just want to step line by line and see what values are inserted into the
Stack table, so that I can validate the code.

Thanks.

--
---------------------
zwieback89

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200701/1

Dan Guzman
1/13/2007 2:55:04 PM

In SQL 2000, you can debug a stored procedure form the Query Analyzer object
browser. Right-click on the proc and select Debug.

--
Hope this helps.

Dan Guzman
SQL Server MVP

[quoted text, click to view]

zwieback89 via SQLMonster.com
1/15/2007 5:50:05 PM

Yes, I tried that. It does open the debugger and then when I run it, it runs
and I do not see the lines within the Stored procedure highlighted where I
can step from line to line and see what it is doing as I step line to line.

Thanks.

--
---------------------
zwieback89

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200701/1

Dan Guzman
1/16/2007 7:03:35 AM

When you click the execute button, the T-SQL Debugger window should open
with an arrow to the left of the next line to be executed. You can step
into line-by-line with F11.

See http://support.microsoft.com/kb/280101 for debugger troubleshooting.

--
Hope this helps.

Dan Guzman
SQL Server MVP

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server programming

sql server programming : How to debug