Every time a stored procedure runs, the following output is displayed in the Data Output view:
When you are debugging a stored procedure that returns multiple result sets, the first result set will be displayed in the Results tab. The second and any subsequent result sets will be displayed as text in the Messages tab.
When you are debugging, the Messages tab displays a Debug started message when the debug session has successfully begun. Similarly, the tab displays a Debug completed message when the debug session ends. In addition, the Messages tab indicates when updates to the database are committed or rolled back.