When you run a query against a database server, it returns a response to the client. There are three types of server response to a SQL query:
Tabular data is displayed in the data editor. Status messages and errors are logged to the Output window. Errors are not only logged to the Output window they are also shown in the Error List window.
The following image represents a general view of the Output window.
Depending on the product, the Output window appearance may vary.
The window can contain up to four output panes (depending on the specific product):
As you can see from the above screenshot, server errors are also logged to the Output window. And you can navigate to the place of an error by double-clicking it on the shortcut menu.
You can search text in the Output window. To find specific text, do the following:
When something goes wrong, typically you see an error. If this is a user or a database server error, such as a mistyped query, in most cases you will see it in the Error List window.
Here is an example of an error displayed in the Error List window.
Error List shows not only errors but also warnings and informational messages which require user attention. A warning is a non-blocking error. And an informational message is just a user notification.
You can filter messages by type using appropriate buttons on the toolbar of the Error List window.
You can navigate to the place of an error by double-clicking it in the list or by selecting Go to Error on the shortcut menu.
Error List aggregates all error messages in the application. And if you have multiple open documents with errors, the error processing can quickly become awkward.
Also, the window has another filter option - In Active Document. This option allows viewing only those errors that are located in the current document window.