The fact that it works on some alerts and not on the other looks like this is not what it intends to be, rather it is some kind of bug.

The problem was resolved on http://dba.stackexchange.com/questions/8928/sql-server-alert-based-on-severity-level-not-working in that a restart of the agent worked, although I don't know why.

Grant Fritchey (6/28/2009)

---

Paul White (6/28/2009)

---

Grant Fritchey (6/28/2009)

---

Every time I ran the query, it picked the widest set of includes, regardless of the order in which the indexes were created. I...