Using Db Maint, Working with…

Exclude SQL Server messages

This dialog allows you to exclude messages from the Db Maint log. Before Db Maint logs a message to the system table, it checks this dialog to see if the message is on the exclude list. By excluding non-important messages, you get a log that is easier to overlook, and you also minimize storage requirement for the Db Maint log.

To open the dialog, right-click anywhere in the right pane while the Db Maint log is showing.

The dialog has two sections: the upper and the lower sections.

The upper section

In this section, you exclude messages by SQL Server error number.

The “Excluded error numbers” tab presents the messages that are excluded, along with the message text.

In “Add error number” you add an error by number. You can also perform a search, based on included sting in message (you can use SQL wildcards, % and _) as well as severity level.

Selecting “Find” takes you to the “Found error numbers” tab. Here you see which error messages where found based on the search. You can select an error and press “Add” to add it to the exclude list.

The lower section

In this section, you exclude message based on a string match. The match can include SQL wildcards (% and _).

You have the option to type a message in free-text form or select one of the messages that currently exists in the Db Maint log.