Post reply

[sql server 2005] - debug a stored procedure

  • November 28, 2006 at 3:19 am

    #171473

    hello world,

    how can i debug a stored procedure under sql server 2005?

  • November 28, 2006 at 4:06 am

    #674283

    unfortunatley microsoft removed it from 2005

    i've seen talk that if you buy visual studio 2005 there is an sql developer/debugger in there - but that's a lot of money

    MVDBA

  • November 28, 2006 at 7:56 am

    #674353

    Hi,

    Whenever I write a stored procedure I call a generic stored procedure INS_DEBUG_LOG before each statement, this generic stored procedure writes to a Debug log table which holds the last statement called and the time it was started (when debugging is switched on). This usually helps me when a particular statement is taking a long time to run.

    Hope this helps!

    Pete

    Peter Gadsby
    Business Intelligence Consultant
    www.hgconsult.co.uk

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply