Claudio Valderrama C. wrote:

>"Duilio Foschi" <dedalus@...> wrote in message
>news:3.0.1.32.20020214230716.00697980@......
>
>>there are tools/tricks that I can use in order to debug/trace triggers and
>>SPs ?
>>
>
>There are only emulators, not true debuggers.
>The truth is that the engine doesn't provide an API to allow debugging.
>

That being said, I find Quickdesk's stored procedure debugger very
useful. It allows you to step through the procedure one line at a time
and see what values are in what variables. Our application has over 350
procedures in it. The debugger has saved me hours of work.

Todder


[Non-text portions of this message have been removed]