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...

Yes.

By all means, give him CREATE TABLE permission on one of the schemas in the database.  But know that if you do that, he'll be dragging data in from production...

No, don't assign the same privileges.  That defeats the object of having separate accounts.  Chances are, you don't need to assign anything manually: if you use SQL Server Configuration Manager...