News

Copyright © 2008-2018 Paula DiTallo

Tag Cloud



How do I Debug my SQL Server Stored Procedures?

If you don't have the Visual Studio IDE to work with, you can go the old fashioned route with issuing PRINT statements.

If you do have the Visual Studio IDE available,  execute the following steps:

  1. open visual studio
  2. navigate to server explorer
  3. create/open a connection to your database
  4. right click on the stored proc you want to work with and choose "Step into stored procedure"

For more details, or for a more visual example with the instructions,  navigate to this url:

http://www.dotnetfunda.com/articles/article27.aspx

 

 

Wednesday, September 8, 2010 7:16 PM

Feedback

No comments posted yet.


Post A Comment
Title:
Name:
Email:
Comment:
Verification: