Additional process debugging and stored procedure debugging

If your project is too large and the normal debugging speed is slow, we can try to attach it to the process for debugging. First, select a breakpoint as usual, then directly run and browse the page to be tested if, then select the tool in vs2005 to attach to the Process

Operating System	HostProcess	ASP. NETProcessName
Windows Server 2003	In IIS 6.0	W3wp.exe
Windows XP	In IIS 5.1	Aspnet_wp.exe
Windows 2000	In IIS 5.0	Aspnet_wp.exe

It's okay. Note that if you need to refresh and reload the items in page_load, You can debug them,

Stored Procedure debugging
Create a data connection in vs2005 server resource manager, select the stored procedure to be debugged, and add the corresponding breakpoint
right-click the stored procedure, select one-step execution of the stored procedure and enter the parameters required by the stored procedure to start debugging.
I remember when someone else tried to debug the stored procedure in sql2005, as if a method in vs2005 called the stored procedure. When this stored procedure was executed, we can debug which of the following experts in sql2005 to tell me ..