I'm using VS.Net and have been told that I can use it to debug my stored procedures in SQL Server 2000. I've had a look on google and MSDN with not much luck, can someone show me how to do this from scratch ?

__________________
All the best

Greg
------------------
Greg Griffiths
Web & Livelink Developer
http://www.greggriffiths.org

Hi Greg,

Don't you know how to set it up, or can't you get it to work?

I know there are some issues with debugging, but in the past I managed to get it to work. I used the following MSDN section as a guideline:

http://msdn.microsoft.com/library/de...asp?frame=true

What's important is that you run Remote Components Setup, even on a local work station (at least, that's what the docs seem to say).

Next, it's important that you enable debugging in your Project's properties dialog and that you set a breakpoint in managed code; if your first breakpoint is in a stored procedure, your code won't break.

Finally, you may need this:

http://support.microsoft.com/?kbid=328151

I needed that in the past to enable debugging; I think that managed code debugging falls under the category "Application Debugging", so you'll need to run the stored procedure they mentioned after each reboot.

Good luck; it's a pain to set up, but a wonderful feature once it works....

(Update: try the support article and "Exec sp_sdidebug 'legacy_on'" first; I just tested it, and it seemed enough to get it to work again on my machine. I looked at my installed programs and didn't see the Remote Debugging Components, so I am not sure you need those)

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Seven Nation Army by The White Stripes (Track 1 from the album: Elephant) What's This?