Debug SQL Server Stored Procedure

How can I debug a Stored Procedure called by an ASP.Net application using SqlCommand.ExecuteScalar function?

You can use SQL Profiler to open a trace to the SQL Server with adding Stored Procedure Events. You can start from here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_mon_perf_51df.asp