SQl debugger ! how

[Raghuraman]

Hi,

Could u tell me how to use the debug tool to debug out t-sql statements .

With Thanks

[Simon Hayes]

"Raghuraman" <ra************@rediffmail.com> wrote in message
news:66**************************@posting.google.c om...

Hi,

Could u tell me how to use the debug tool to debug out t-sql statements .

With Thanks

In Query Analyzer, open the Object Browser (press F8), find the stored
procedure you want to debug, then right-click it and select Debug. Although
the debugger only supports stored procedures, if you want to debug SQL
batches or functions, then you can just wrap them in a dummy procedure, and
debug them that way.

Simon

[Trevor Best]

On Thu, 20 Nov 2003 20:22:20 +0100 in comp.databases.ms-sqlserver,
"Simon Hayes" <sq*@hayes.ch> wrote:

"Raghuraman" <ra************@rediffmail.com> wrote in message
news:66**************************@posting.google. com...

Hi,

Could u tell me how to use the debug tool to debug out t-sql statements .

With Thanks

In Query Analyzer, open the Object Browser (press F8), find the stored
procedure you want to debug, then right-click it and select Debug. Although
the debugger only supports stored procedures, if you want to debug SQL
batches or functions, then you can just wrap them in a dummy procedure, and
debug them that way.

Spin my nipple-nuts and send me to Alaska, do you know how many years
I've debugged SPs using print statements????????? Grrrrrrr!

Thanks for that.

--
A)bort, R)etry, I)nfluence with large hammer.