Using T-SQL Debbugger

  • Hi, friends !

    I don't understand !

    I want to debug a stored procedure.

    I open the T-SQL Debugger, and in window "Debug Procedure",

    I setting the  values of the parameters.

    Then I click on "Execute".

    What happen now? (in my case !)

    In the right of window "T-SQL Debugger",  don't appear (!)

    the arrow, the indicator, of the next statement to execute.

    The stored running and arrived to an end.

    Why ??

    I don't suceeded to debug a stored procedure !!

    Anybody can Help me ??

    Thank you very much !

    Flavio

  • See if this helps.

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;310650

    It will also lead you to other articles

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Thank you very much,  Frank !

    I have installed SP3a on my SQL Server, and now, it seems that function!!

    Thanks

    Flavio

  • Dear All

    My name is Dharmendra I am new to this Job DBA i recently placed at the client side. Pls can anyone help me out how to run the T-SQL Debugger.

    Any Help is greatly appreciated

    Dharmendra Mudaliar

    Thanks & Regards
    Dharmendra S Mudaliar
    ( OEM India RSA )
    Hello - +91 40 66934555 x 34555
    Mobile - 9885408049 | IM - v-dharmu@microsoft.com

  • See if this Topic in BOL helps: "Transact-SQL Debugger window"

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

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