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

Debugging Stored Procedures

Hello,

I've posed this question in the MS-SQL area and hasn't gotten any response, hopefully someone can provide an answer.  I'm trying to use the t-sql debugger in VB.  I have it set up to where I create a data link to a database on my local machine, open the stored procedures folder and right click "debug".  It pulls up the t-sql debugger window.  When I click run, a message pops up and says "The query could not be debugged due to a problem coordinating events with the server".  It then displays in the bottom window "RETURN VALUE =0", and nothing happens.  I've been struggling with this, and can't seem to find any resource for the t-sql debugger. Can someone provide me with a step-by-step resource on how to debug stored procedures using the t-sql debugger in VB or in SQL Server Query Analyzer.  Also, are there any free products out there that will debug stored procedures and/or triggers

Thanks
0
tinman1412
Asked:
tinman1412
1 Solution
 
vbDocCommented:
0
 
rspahitzCommented:
I don't knwo if this helps, but when I used to work with SQL*Server stored procedures, I just added messages along the way to ensure that it reached certain points in the st-proc.  This is not the best way but is easy.
0
 
tinman1412Author Commented:
Yes, I've been using the print statements, but when you have a good size stored procedure or trigger, it can be a pain
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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