Geeks With Blogs
faizan ahmad Usually the things which were not a straight Google
It s really easy to debug a SQL sever stored procedure in Visual Studio, here are the steps:

  1. Open Server Explorer
  2. Connect to the Database which have the stored procedure that you want to debug
  3. Once you are connected to a DB, it will display DB objects in Server Explorer, Click  to expand Stored Procedures
  4. Right Click on the Stored Procedure ( that you want to debug ) 
  5. 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
Requesting Gravatar...
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
Requesting Gravatar...
wanted to know how to debug stored procedure
Left by vijayalakshmi chakka on Jan 13, 2009 5:00 PM

Your comment:
 (will show your gravatar)


Copyright © faizanahmad | Powered by: GeeksWithBlogs.net