Database Projects - Debugging SPs

Database Projects - Debugging SPs

am 20.10.2007 22:36:01 von EdB

When you add a DB project to a solution, can you put a breakpoint and step
through stored procedures?

When I try to place a breakpoint, it will put it there before I start
debugging the project, but then when it starts it changes to a hollow circle
and says "The breakpoint will not currently be hit, No symbols have been
loaded for this document".

Re: Database Projects - Debugging SPs

am 23.10.2007 10:25:19 von Andrew Faust

This article shows how to step in to a stored procedure

http://aspnet.4guysfromrolla.com/articles/051607-1.aspx#post adlink

--
Andrew Faust
andrew[at]andrewfaust.com
http://www.andrewfaust.com


"EdB" wrote in message
news:B7FDC6F5-45A9-49BA-A1BD-F285E88B596A@microsoft.com...
> When you add a DB project to a solution, can you put a breakpoint and
> step
> through stored procedures?
>
> When I try to place a breakpoint, it will put it there before I start
> debugging the project, but then when it starts it changes to a hollow
> circle
> and says "The breakpoint will not currently be hit, No symbols have been
> loaded for this document".
>

Re: Database Projects - Debugging SPs

am 23.10.2007 14:20:00 von EdB

Thanks. I thought I tried the "Step Into Stored Procedure" method and all it
did was run through it. Perhaps I missed one of the steps laid out here.
I'll check this all out.

"Andrew Faust" wrote:

> This article shows how to step in to a stored procedure
>
> http://aspnet.4guysfromrolla.com/articles/051607-1.aspx#post adlink
>
> --
> Andrew Faust
> andrew[at]andrewfaust.com
> http://www.andrewfaust.com
>
>
> "EdB" wrote in message
> news:B7FDC6F5-45A9-49BA-A1BD-F285E88B596A@microsoft.com...
> > When you add a DB project to a solution, can you put a breakpoint and
> > step
> > through stored procedures?
> >
> > When I try to place a breakpoint, it will put it there before I start
> > debugging the project, but then when it starts it changes to a hollow
> > circle
> > and says "The breakpoint will not currently be hit, No symbols have been
> > loaded for this document".
> >
>