Post reply

BreakPoint in SSMS

  • September 2, 2010 at 8:46 am

    #228646

    Hello Everyone

    I can see there can be a breakpoint set in SSMS, but how can I see the value(s) of the variables?

    I have set a breakpoint, and it will stop at that point, but I cannot see the value of any variables.

    What should I do, or set, or hover over?

    Thanks in advance

    Andrew SQLDBA

  • September 9, 2010 at 12:31 pm

    #1218847

    Hi, Andrew. Did you ever figure this one out?

  • September 9, 2010 at 12:36 pm

    #1218850

    Yes, but it only works with SQL 2008.

    There is good info in the SQL Books Online as well. Read the BOL to figure out how to setup the respective environments.

    Just set a BreakPoint in SSMS, and press Alt + F5 and that will start the Debug, and then F11 to step into. Why they could not use F8 like Visual Studio, I have no idea.

    It works pretty good, you see the variable values in the watch window instead of hovering your mouse over the variable name. Some things are different, it just takes some getting used too.

    Andrew SQLDBA

  • September 9, 2010 at 12:38 pm

    #1218852

    Thanks very much, Andrew. Your help is much appreciated!

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

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