By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,239 Members | 1,503 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,239 IT Pros & Developers. It's quick & easy.

VS .NET Debugging

P: n/a
Taking a course that shows an example of being able to setup a breakpoint in
an SQL Stored procedure (northwind) from VS VB .NET IDE.

I set the break points in the procedure, they look ok. Start debug and I see
a question mark on the break point (Something about no symbols being loaded)
and of course while the stored procedure does execute and return results,
the break point never kicks in.

The course makes a quick reference that it will work if you have debug
permission on the SQL Server(but no other explenation or details).

Chasing my tail trying to find out how to make it work. Does anyone know? I
have found bad information in the course about things I do know about,
trying to find out what detail they left out of this example.

Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Lost,

I thought that I have seen the answer on this in the newsgroup

Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:
<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet.framework.adonet>

However do not know it anymore, maybe you can search it yourself. I thought
that the answer was given by Bill Vaughn (search on his last name) however
from that I am again not sure

http://groups.google.com/groups?hl=e...amework.adonet

I hope this helps a little bit?

Cor

Taking a course that shows an example of being able to setup a breakpoint in an SQL Stored procedure (northwind) from VS VB .NET IDE.

I set the break points in the procedure, they look ok. Start debug and I see a question mark on the break point (Something about no symbols being loaded) and of course while the stored procedure does execute and return results,
the break point never kicks in.

The course makes a quick reference that it will work if you have debug
permission on the SQL Server(but no other explenation or details).

Chasing my tail trying to find out how to make it work. Does anyone know? I have found bad information in the course about things I do know about,
trying to find out what detail they left out of this example.

Nov 21 '05 #2

P: n/a
Looked through a lot of pages to no avail. Documentation is confusing me.
But, I believe an extended procedure is a procedure that is wrtitten within
VS .NET, so sp_sdidebug is not what I am looking for. Did see VS .NET
reference to DBG and PDB files. Did find some of those in SQL folder, but
pointing to them doesn't help.

Did see one reference in google that seemed to imply that it couldn't be
done. Anybody out there using the technique?

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:eX*************@TK2MSFTNGP11.phx.gbl...
Lost,

I thought that I have seen the answer on this in the newsgroup

Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:
<http://communities2.microsoft.com/co...s/?dg=microsof t.public.dotnet.framework.adonet>

However do not know it anymore, maybe you can search it yourself. I thought that the answer was given by Bill Vaughn (search on his last name) however
from that I am again not sure

http://groups.google.com/groups?hl=e...amework.adonet
I hope this helps a little bit?

Cor

Taking a course that shows an example of being able to setup a breakpoint
in
an SQL Stored procedure (northwind) from VS VB .NET IDE.

I set the break points in the procedure, they look ok. Start debug and I see
a question mark on the break point (Something about no symbols being

loaded)
and of course while the stored procedure does execute and return

results, the break point never kicks in.

The course makes a quick reference that it will work if you have debug
permission on the SQL Server(but no other explenation or details).

Chasing my tail trying to find out how to make it work. Does anyone

know? I
have found bad information in the course about things I do know about,
trying to find out what detail they left out of this example.


Nov 21 '05 #3

P: n/a
Funis,

I did not see you placed your message in the newsgroup I recomended you.

I surely would do that.

However keep in mind weekend will be started, I am not sure if the ones who
now are active know the answer on your question so maybe you have to wait
for after the weekend on an answer.

(It is a very active newsgroup, maybe not as this however one of the major
developper newsgroups)

Cor
Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.