debugging tools

i would like to know if there is a way to 'step through sql server t-sql
commands'
using one of the sql server 200 tools, sql server managment studio, or
viusal studio .net 2005 professtional version? If so can you give me
directions on how to 'step through' (debug) the t-sql commands. if not, what
tool that can be used to debug the t-sql commands?
thanks!
Wendy Elizabeth wrote:

> i would like to know if there is a way to 'step through sql server t-sql
> commands'
> using one of the sql server 200 tools, sql server managment studio, or
> viusal studio .net 2005 professtional version? If so can you give me
> directions on how to 'step through' (debug) the t-sql commands. if not, what
> tool that can be used to debug the t-sql commands?
If nothing else, you could highlight and execute a few lines
at a time, and/or intersperse some PRINT statements.
|||Visual Studio (Pro and higher) has TSQL debugging. Create a project of "Database Project" type
(found in "Other Project Types\Database" folder). Specify the desired data source.
View, Server Explorer.
Double-click a stored procedure.
Set breakpoints.
Right-click the proc and select "Step Into".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Wendy Elizabeth" <WendyElizabeth@.discussions.microsoft.com> wrote in message
news:AE3CB536-778F-47AD-AD64-9CA0B6827073@.microsoft.com...
>i would like to know if there is a way to 'step through sql server t-sql
> commands'
> using one of the sql server 200 tools, sql server managment studio, or
> viusal studio .net 2005 professtional version? If so can you give me
> directions on how to 'step through' (debug) the t-sql commands. if not, what
> tool that can be used to debug the t-sql commands?
> thanks!
|||hi Wendy,
Wendy Elizabeth wrote:
> i would like to know if there is a way to 'step through sql server
> t-sql commands'
> using one of the sql server 200 tools, sql server managment studio, or
> viusal studio .net 2005 professtional version? If so can you give me
> directions on how to 'step through' (debug) the t-sql commands. if
> not, what tool that can be used to debug the t-sql commands?
in addition to Tibor's answer, please have a look at
http://msdn2.microsoft.com/en-us/library/zefbf0t6(VS.80).aspx as well..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||i will try
"Ed Murphy" wrote:

> Wendy Elizabeth wrote:
>
> If nothing else, you could highlight and execute a few lines
> at a time, and/or intersperse some PRINT statements.
>
|||Hi Wendy,
I suggest you try the tool SQL Ultimate Debugger:
http://lakesidesql.com/downloads/PFD/1_0_2007_809/PFDebugger_Setup_08-09-2007.zip.
This tool is a post factum debugger and allows you to trace and
debug obejcts (SP's Triggers, FN's, etc.) that had been executed. It's
waaaay better than the T-SQL debugger in VS. Also, since this software has
not yet been officially realeased, I would not recommend (YET) to use it in
a production environment.
You can learn more about it here:
http://208.75.249.50/products/sql-ultimate-debugger/screenshots.html. If you
want a copy of its documentation. shoot me an email and i can send it to
you.
I hope that helps.
"Wendy Elizabeth" <WendyElizabeth@.discussions.microsoft.com> wrote in
message news:AE3CB536-778F-47AD-AD64-9CA0B6827073@.microsoft.com...
>i would like to know if there is a way to 'step through sql server t-sql
> commands'
> using one of the sql server 200 tools, sql server managment studio, or
> viusal studio .net 2005 professtional version? If so can you give me
> directions on how to 'step through' (debug) the t-sql commands. if not,
> what
> tool that can be used to debug the t-sql commands?
> thanks!