views:

352

answers:

2

I was looking for a good free debugger for STP (Stored Procedures) as I need to make changes to a few of them as a part of my recent project. The stored procedures are stored in independent '.sql' files and not in the code.

A debugger would speed things up quite a it in my case. Could anyone recommend any tools that can be used for this?

+1  A: 

The stored procedures are stored in independent '.sql' files and not in the code.

In order to debug a proc it has to be created in the RDBMS and then executed, how will you debug a proc stored in a file?

SQLMenace
A: 

@SQLMenace:

Yes, you are right. These stored procedures are called through code which has all the necessary libraries to connect to the database (RDBMS).

However, what I am looking for is to understand what the stored procedures do. At the moment I am using dbVisualizer for this. I have set up the connections to the RDBMS in the tool, so I am able to run individual queries into the database.

The free version of dbVisualizer, does not allow the debugging of stored procedures. Hence the reason to look for another tool which can help me do this.

I apologize for not including enough detail into the original question.

Thanks.

Pascal