Hi,
Could u tell me how to use the debug tool to debug out t-sql statements .
With Thanks
Could u tell me how to use the debug tool to debug out t-sql statements .
With Thanks
-
-
Re: SQl debugger ! how
"Raghuraman " <raghuraman_ace @rediffmail.com > wrote in message
news:66c7bef8.0 311200723.24df4 749@posting.goo gle.com...[color=blue]
> Hi,
>
> Could u tell me how to use the debug tool to debug out t-sql statements .
>
> With Thanks[/color]
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
-
Re: SQl debugger ! how
On Thu, 20 Nov 2003 20:22:20 +0100 in comp.databases. ms-sqlserver,
"Simon Hayes" <sql@hayes.ch > wrote:
[color=blue]
>
>"Raghuraman " <raghuraman_ace @rediffmail.com > wrote in message
>news:66c7bef8. 0311200723.24df 4749@posting.go ogle.com...[color=green]
>> Hi,
>>
>> Could u tell me how to use the debug tool to debug out t-sql statements .
>>
>> With Thanks[/color]
>
>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.[/color]
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.
Comment
Comment