Can't set breakpoint when debugging stored procedure on SQL 2008R2

• halifaxdal

  SSCoach

  Points: 19741

  More actions

  February 6, 2013 at 8:16 am

  #268136

  I am trying to debug a stored procedure on my local SQL 2008 R2 server, why I can't set any breakpoint? I am using Visual Studio 2008 Pro.

  The server is a new installation, maybe there is some setting missing?

  Thanks.

• halifaxdal

  SSCoach

  Points: 19741

  More actions

  February 6, 2013 at 1:47 pm

  #1585127

  I found the cause: I have another debugging process running, once that one stops, this one works.