Re: Any way to debug using SQL SP
From: Rena (rena_at_mail.hongkong.com)
Date: 09/02/04
- Next message: Rick Sawtell: "Re: File Size - Probably missing something basic..."
- Previous message: Rick Sawtell: "Re: logging changes for nested tables"
- In reply to: Rick Sawtell: "Re: Any way to debug using SQL SP"
- Next in thread: HappyHarry: "Re: Any way to debug using SQL SP"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 22:46:24 +0800
Thx all for the helps~~~ :)
"Rick Sawtell" <ricksawtell@hotmail.com> wrote in message
news:OR$tKoDkEHA.1800@TK2MSFTNGP15.phx.gbl...
> 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
>
>
>
- Next message: Rick Sawtell: "Re: File Size - Probably missing something basic..."
- Previous message: Rick Sawtell: "Re: logging changes for nested tables"
- In reply to: Rick Sawtell: "Re: Any way to debug using SQL SP"
- Next in thread: HappyHarry: "Re: Any way to debug using SQL SP"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
