I don't really understand your requirement, but in trying to get to grips with it, I noticed that you have a denormalised design and the wrong data types.  Parent_Group_ID should...

Nah, I've never smoked.  But thanks for the offer!

I wasn't necessarily suggesting that you increase the scope of your alerting.  I was just showing how you can reduce...

Please can I exchange it for a nice single malt?

The xp_readerrorlog proc takes up to two search parameters, so you can make your code more efficient, something like...

OK, so there are 16 different types of login failure message, and you have 36 instances of login failure messages in your errorlog.  That makes sense to me.  It sounds...

That's not what I mean.  The table contains each possible message, but not each instance of when they were raised.  As I understand it, if is_event_logged is 1, an entry...

I think it's to do with sys.messages, not SQL Server Agent alerts.

SELECT
     m.message_id
,    m.severity
,    m.text FROM sys.messages m
JOIN sys.syslanguages l ON m.language_id =...

I'm not entirely sure, although I can see severity 14 and severity 18 errors in the errorlog of one of our servers.

Edit - take a look at the...

In the sample data you provided, there's a group for each distinct date and each distinct date is in its own group.  Please post some more sample data illustrating a...

I think I'd just use xp_readerrorlog to pull all error details into a table, then poll that and alert accordingly.

John

Actually, I think you may need ALTER permission on the schema.  Make sure you understand the dangers of doing this - explained here.

John

This may be due to the new cardinality estimator (CE) that was introduced with SQL Server 2014.  Is your database at compatibility level 130?  Have a look at the (actual)...

Thanks Steve - I'll give it a try, in that case.  I assume they must therefore convert dollars to pounds at point of sale.  Having said that, it's not an...