debugging an SQL Server 2000 stored procedure...

[Brad Pears]

I have a vb.net 2005 app that calls strored procedures. I am having
difficulties with one of my stored procs and thought I'd try to debug it
from my vb app. I went to the server explorer page, expanded my connection
then selected the stored procedures. I then selected the stored proc I want
to debug. I set a breakpoint and then ran my project. I then get a "A
breakpoint will not currentrly be hit. No symbols have been loaded for this
document" error.

I am not sure what I am missing here...

Can someone step me through what I need to do to be able to debug a stored
procedure?

Thanks!
Brad

[sstory]

Re: debugging an SQL Server 2000 stored procedure...

does this help?

http://articles.techrepublic.com.com/5100-10878_11-5161626.html

"Brad Pears" <bradp@truenort hloghomes.comwr ote in message
news:OEFFQLnHJH A.2296@TK2MSFTN GP03.phx.gbl...

>I have a vb.net 2005 app that calls strored procedures. I am having
>difficulties with one of my stored procs and thought I'd try to debug it
>from my vb app. I went to the server explorer page, expanded my connection
>then selected the stored procedures. I then selected the stored proc I want
>to debug. I set a breakpoint and then ran my project. I then get a "A
>breakpoint will not currentrly be hit. No symbols have been loaded for this
>document" error.
>
I am not sure what I am missing here...
>
Can someone step me through what I need to do to be able to debug a stored
procedure?
>
Thanks!
Brad
>