Debugging with code break points

[UnsolvedCoding]

In VBA you can place stops by using F9 to stop the code so you can check things and can do things like hover the mouse over something or use the watch window to see the value of an item.

Is there a way to do the same things in SQL?

I have a very annoying stored procedure to figure out and have to go line by line or less to find the issues.

 

[simian336]

ssms 2008 has breakpoints, pervious versions do not.

simi

 

[SQLBill]

When I trouble shoot code, I will look for places where I need to know what is happening and then I will put in PRINT statements.

For example, I want to know what value is entered into @somevariable. I will have a print statement like:

PRINT @somevariable

I'll do this throughout the code. I'll also add print statements that just return the GETDATE() so I know how long each section runs.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875