Welcome! and rules
Joel on Software
How to debug stored procedures in .Net?
Hey there. So, all the docs say you can debug Sql Server stored procedures directly from .Net, but all the functions the docs mention do not show up when I attempt to use them in .Net. For instance, one doc says to right click the stored procedure under the server explorer window and select "step into procedure". Well, when I right click a proc in the server window, that is not an option. Did I not install a component or add-in when I installed .Net? I installed the full, professional edition. Any ideas?
I think it's an VS.NET Enterprise Architect/Enterpise Developer feature only, I'm afraid.
Make sure you have all the necessary files in place to debug stored procedures. For details check out this article @ http://www.fawcette.com/vsm/2002_11/magazine/columns/databasedesign/
Fog Creek Home