Debugging tips

[ptmcs]

Hi All,

Has anyone got any great hints/tips for debugging stored procs/triggers.

I'm getting 'fed up!!' of adding print statements / writing off to temporary tables etc...

Tried DBartisan 7 with 'step through/watch' etc etc
(proper debugging stuff!) but that spends most of its time crashing..... !

 

[tinkuK]

Hi
What I do to debug stored procedure is to run each individual statement/block seperate in editor and see the results for each run. Once the statement/block is executed then process on to next statement/block in the sp

definetly we will find where exatly we are going out of the box with the above way.

Hope you will also like this

Regards
Gopal