Debug stored procedure

faizan ahmad Usually the things which were not a straight Google

<< join in SQL update statement | Home | Fixed Header for Data Repeater Control >>

Comments (2) | Share

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'

Posted on Monday, January 5, 2009 11:46 AM SQL Server | Back to top

Comments on this post: Debug stored procedure

# re: Debug stored procedure

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

Left by Stacy Vicknair on Jan 05, 2009 12:46 PM

# re: Debug stored procedure

wanted to know how to debug stored procedure

Left by vijayalakshmi chakka on Jan 13, 2009 5:00 PM

Your comment:

Title:

Name:

Email: (never displayed) (will show your gravatar)

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Verification: