Debug stored procedure

It s really easy to debug a SQL sever stored procedure in Visual Studio, here are the steps:

Open Server Explorer
Connect to the Database which have the stored procedure that you want to debug
Once you are connected to a DB, it will display DB objects in Server Explorer, Click to expand Stored Procedures
Right Click on the Stored Procedure ( that you want to debug )
Click on 'Step Into Stored Procedure'

Share This Post:

posted on Monday, January 05, 2009 11:46 AM

Feedback

# re: Debug stored procedure 1/5/2009 12:46 PM Stacy Vicknair

I just wanted to comment that there may be the necessity of some SQL Server configuration before you can debug a stored procedure. The following MSDN article might help those who are enabling SQL Server debugging for the first time:

http://msdn.microsoft.com/en-us/library/s4sszxst(VS.80).aspx

# re: Debug stored procedure 1/13/2009 5:00 PM vijayalakshmi chakka

wanted to know how to debug stored procedure

faizan ahmad

News

Archives

Post Categories

.NET

ASP.NET

Feedback