• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

Is there any way of debugging a Stored Procedure step by step?

Is there any way of debugging a Stored Procedure step by step?
Environment: VS 2005, SQL 2005, .NET 2.0
0
chuang4630
Asked:
chuang4630
1 Solution
 
SStoryCommented:
there may be a debugger in the newer tools, but if not the old way...

   use the print statement after each line to see what is happening.
0
 
DhaestCommented:
Using VS.NET to debug database stored procedures
http://articles.techrepublic.com.com/5100-10878_11-5161626.html

Debug Stored Procedures in VB.NET - Use the VS.NET debugger to step through T-SQL.
http://www.ftponline.com/vsm/2002_11/magazine/columns/databasedesign/
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now