debugging SPs in vs.net

[sorry but my first post got a "non-answer" so I am reposting]
I have followed examples in a couple of books but am still unable to step
into Stored Procedures in VS.NET.
I enable sql debugging in the project properties, open the sp in server
explorer and highlight a line where I want to start stepping through, then I
select a line in my VB code such as cmd.ExecuteNonQuery().
But vs.net does not step into the SP it just steps over the
cmd.ExecuteNonQuery() even though I am clicking on the Step Into icon on the
toolbar (F8 doesn't work on my computer)
Am I missing something?
Thanks,
GG Dean Blake wrote:
> [sorry but my first post got a "non-answer" so I am reposting]
> I have followed examples in a couple of books but am still unable to
> step into Stored Procedures in VS.NET.
> I enable sql debugging in the project properties, open the sp in
> server explorer and highlight a line where I want to start stepping
> through, then I select a line in my VB code such as
> cmd.ExecuteNonQuery().
> But vs.net does not step into the SP it just steps over the
> cmd.ExecuteNonQuery() even though I am clicking on the Step Into icon
> on the toolbar (F8 doesn't work on my computer)
>
Have you browsed through the other questions in this newsgroup? Have you
seen any questions dealing with vs.net? Maybe that should be an indication
that you've asked in the wrong place.
There are several newsgroups (communities) set up for the .Net framework -
they all have the word "dotnet" in their names. The one you want probably
has both "vsnet" and "debug" or "debugging" in its name. I don't have time
to find it right now, but I think you have enough clues now to find it
yourself ... :-)
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.|||Well, the two answers I have gotten in other groups (.net groups) were that
it doesn't work but everyone seems pretty closed mouth about it. Since
practical alternatives might be to use another tool, I though I would try
this group since (1) a lot of people here probably debug stored procedures,
and (23) most MS oriented developers use .net anyway.
but, I am very sorry for asking here.
G
"Bob Barrows [MVP]" <reb01501@.NOyahoo.SPAMcom> wrote in message
news:OCyHmTiCFHA.520@.TK2MSFTNGP09.phx.gbl...
>G Dean Blake wrote:
> Have you browsed through the other questions in this newsgroup? Have you
> seen any questions dealing with vs.net? Maybe that should be an indication
> that you've asked in the wrong place.
> There are several newsgroups (communities) set up for the .Net framework -
> they all have the word "dotnet" in their names. The one you want probably
> has both "vsnet" and "debug" or "debugging" in its name. I don't have time
> to find it right now, but I think you have enough clues now to find it
> yourself ... :-)
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>|||G Dean Blake wrote:
> Well, the two answers I have gotten in other groups (.net groups)
> were that it doesn't work but everyone seems pretty closed mouth
> about it. Since practical alternatives might be to use another tool,
> I though I would try this group since (1) a lot of people here
> probably debug stored procedures,
This is true. But most people in this group generally concentrate on using
SQL Query Analyzer for this. My suggestion is to try and get debugging
working in Query Analyzer. This seems to be a prerequisite for getting it to
work in vs.net, at least in my experience.

> and (23) most MS oriented
> developers use .net anyway.
This is not true. .Net is still relatively new.

> but, I am very sorry for asking here.
> G
Oops, you're apologizing. I did not intend to make you feel as if you had to
apologize. I was trying to explain why you weren't getting help here. I
worded my reply badly so I apologize. (kumbaya ... ) <grin>
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.