How do I debug from ASP.NET to SQL Server?

Question

Basically what I want to do is start a debug on a web page and then F10 into cmd.ExecuteNonQuery which would take me to SQL Server/SSMS and allow me to see what the actual stored procedure is doing.

Is there a way to do this (or something like this)?

use the debugger in SQL Server Management Studio, set a breakpoint in your SP and wait until it gets executed — Dunken
– Dunken, Commented Mar 31, 2014 at 18:53

TheEdge · Accepted Answer · 2014-04-01 04:28:55Z

2

Another approach is to use Glimpse http://getglimpse.com/ to profile what is happening. This will show you the SQL being executed as well as a whole heap of other information.

answered Apr 1, 2014 at 4:28

TheEdge

10.1k18 gold badges76 silver badges148 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shay · Accepted Answer · 2014-03-31 19:00:49Z

0

The easy way will be to use the SQL Server Profiler in the SSMS (Tool -> SQL Server Profiler).

It will allow you to view the command that your website executed. After tha, if needed, you can copy the command and execute it in a new query with debugging.

You can look at this MSDN site for guides about how to run specific tasks.

answered Mar 31, 2014 at 19:00

Shay

1,7763 gold badges27 silver badges41 bronze badges

Collectives™ on Stack Overflow

How do I debug from ASP.NET to SQL Server?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related