Use the DB Output view

Every time a stored procedure runs, output appears in the DB Output view as follows:

• Generated messages appear in the Messages tab.

• If the stored procedure requires parameters, they will appear in the Parameters tab.

• If the stored procedure returns records from the database in a result set, the result set will appear in the Results tab.

When you are debugging a stored procedure that returns multiple result sets, the first result set will appear in the Results tab. The second and any subsequent result sets will appear as text in the Messages tab.

When you are debugging, the Messages tab also indicates that updates to the database are committed or rolled back. When the Commit after running a stored procedure check box in the preferences is selected, database updates resulting from the running stored procedure are committed to the database and this is indicated in the DB Output view Messages tab. When this check box is not selected, database updates are not committed and the Messages tab indicates that changes are rolled back. By default, database updates are committed.

 

Related tasks

Setting stored procedure debug preferences