This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
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
Pls suggest
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
OK, understood. That doesn't change my answer. You have to create 25 alerts. One per severity level.
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.)
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.
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
Hi @BilalBhat-0178,
Is the reply helpful?
Do you solve the issue?
If the reply is helped,please do "Accept Answer".
BR,
Mia