the 2008 t-sql debugger harbors an enigma...

  • if you invoke the debugger and try to set a breakpoint so that the code stops on a condition, there is a column in the breakpoint dialog that says 'Condition', but i cannot figure out how to change it.

    Is it there so you can change it just there for looking at (a good idea that never happened)?

    thanks very much

    drew

  • Per Books Online:

    BOL- debugging [SQL Server], Transact-SQL debugger (Breakpoints Window)


    To access the Breakpoints window

    On the Debug menu, click Windows, and then click Breakpoints.

    Breakpoints Window ColumnsBy default, the Breakpoints window lists the following columns.

    Name Displays the name of the breakpoint. Breakpoint names are provided by the debugger. This name includes the name of Database Engine Query Editor window that contains the breakpoint, and the line number in the Query Editor on which the breakpoint is set.

    Condition Displays (no condition). The Transact-SQL debugger does not support setting breakpoint conditions.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • forgive me, should have looked there first.

    but i thought it was plain as day....

    thanks very much

    drew

  • You're welcome. And FYI: I had to link through three entries to find it, so even if you had looked, you might not have seen it.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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