Configure DB alert

Question

Hello,

I am configuring alert for Prodcution databases.
I want to get any error message appearing in SQL Server Error log. But while defining the alert it is showing 2 options

1. Error No
2. Severity

Pls suggest

Answer 1

OK, understood. That doesn't change my answer. You have to create 25 alerts. One per severity level.

Answer 2

If you need every single message then you need to configure 25 alerts, one per severity level. There is no "include all" option. (You will probably find out that there are bunch of messages that you aren't interested in, btw.)

Answer 3

Actually in my SQL server error logs, I don't have any error messages unless something wrong happens, so I want to catch any error message.

Answer 4

Hi @BilalBhat-0178,

As @tibor_karaszi@hotmail.com ‘s suggestion:
Error severity: 25,
What it indicates: Unexpected errors, this is the catch all for Microsoft SQL Server.

More information: sql-server-setup-database-alerts, create-configure-sql-server-agent-alerts

If the reply is helped, please do “Accept Answer”.
BR,
Mia

Answer 5

Hi @BilalBhat-0178,

Is the reply helpful?
Do you solve the issue?

If the reply is helped,please do "Accept Answer".
BR,
Mia