<p>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 <code>.sql</code> files and not in the code.</p>

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

[{'answer_id': 18116, 'author': 'SQLMenace', 'author_id': 740, 'author_profile': 'https://Stackoverflow.com/users/740', 'pm_score': 1, 'selected': False, 'text': "<blockquote>\n  <p>The stored procedures are stored in independent '.sql' files and not in the code.</p>\n</blockquote>\n\n<p>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?</p>\n"}, {'answer_id': 18152, 'author': 'Pascal', 'author_id': 1311, 'author_profile': 'https://Stackoverflow.com/users/1311', 'pm_score': 0, 'selected': False, 'text': '<p>Yes, you are right. These stored procedures are called through code which has all the necessary libraries to connect to the database (RDBMS). </p>\n\n<p>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.</p>\n\n<p>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.</p>\n\n<p>I apologize for not including enough detail into the original question.</p>\n\n<p>Thanks.</p>\n'}, {'answer_id': 71244602, 'author': 'eric', 'author_id': 1639388, 'author_profile': 'https://Stackoverflow.com/users/1639388', 'pm_score': 0, 'selected': False, 'text': '<p>Aqua Data Studio does this. For instance see\n<a href="https://www.aquafold.com/aquadatastudio/sql_server_sql_debugger/" rel="nofollow noreferrer">https://www.aquafold.com/aquadatastudio/sql_server_sql_debugger/</a>\n<a href="https://www.aquafold.com/aquadatastudio/oracle_sql_debugger/" rel="nofollow noreferrer">https://www.aquafold.com/aquadatastudio/oracle_sql_debugger/</a>\netc.\nStep over, step into, breakpoints, watch variables, etc.</p>\n'}]
['https://Stackoverflow.com/questions/18104', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1311/']