CODEWITHSUNDEEP
asp.netsql-serverdebuggingssms
dotnetN00b
dotnetN00b

Reputation: 5131

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

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)?

Upvotes: 0

Views: 280

Answers (2)

TheEdge
TheEdge

Reputation: 9861

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.

Upvotes: 2

Shay
Shay

Reputation: 1778

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.

Upvotes: 0

Related Questions