SQLTeam.com | Weblogs | Forums

SQL 2008R2 Debugger reports no source


First time post on these forums.

Have a large SP that calls many helper functions and additional SP's and for some reason the debugger will not step into a recently added SP, steps into all others just fine.
Receive the following error;

There is no source code available for the current location

No obvious answers on the net so far. Relaunched SSMS, Re-created the sub SP, verified the SP is being called by embedded PRINT statements.

Seems like some META data is confused.



See if some source files are accidentally excluded. Do properties of the solution and look at the Debug Source Files section under Common Properties.

Not using Solution Explorer or Projects as my source is in a local replicated repository directory structure