SQLTeam.com | Weblogs | Forums

SQL 2008R2 Debugger reports no source

tsql
sql2008r2

#1

Greetings,

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.

Thoughts?

Kurt


#2

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


#3

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