Debugging in SQL Management Studio 2012

Question

I am using Management Studio 2012, but I can not debug the SQL code. After I clicked the Debug button, I don't get the green arrow to the left, and none of my SQL objects are loaded into memory.

I get this message when I click on the breakpoint I set: The breakpoint will not currently be hit. Unable to bind SQL breakpoint at this time. Object containing the breakpoint not loaded. The breakpoint will not currently be hit. Unable to bind SQL breakpoint at this time. Object containing the breakpoint not loaded.

I watched a youtube video demonstrating how to debug in Studio 2012: http://www.youtube.com/watch?v=_jsFM_PUPgA&feature=relmfu The guy in the video writes a small SQL query around 4:30, puts a breakpoint in SELECT and clicks on Debug . Then he will get a small green arrow in the upper left corner of the editor, as well as his breakpoint. My not.

This is what I would like to debug:

 declare @count int = 0 while @count <> 10 begin select @count set @count = @count + 1 end 

This is pretty simple, and debugging should work. Of course, I would like to debug more complex stored procedures later ..

Any suggestions?

Answer 1

I realized that I was trying to debug from a remote machine. Logging into the server computer and debugging locally worked.

Answer 2

I made a short video on YouTube that shows how to debug a T-SQL query in SSMS SQL Server 2012 - here is the link. If this does not help, it may be useful if you publish a short video about the steps you take, and then edit your answer to include this video, then I will watch and try to advise from there.