Blog Stats
  • Posts - 14
  • Articles - 0
  • Comments - 14
  • Trackbacks - 0

 

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

Debug stored procedure

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'

Print posted @ Monday, January 05, 2009 11:46 AM

Feedback

# re: Debug stored procedure

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 1/5/2009 12:46 PM | Stacy Vicknair

# re: Debug stored procedure

Gravatar wanted to know how to debug stored procedure 1/13/2009 5:00 PM | vijayalakshmi chakka
Post a comment





 

 

 

 

Copyright © faizanahmad