I had a load of email alerts over the weekend for Deadlocks and Blocked processes. The deadlock alerts were 12kb in size but the Blocked process alerts were a whopping 9mb each! I got a telling off from my email admin about disk space on our email server. From what I can see it looks like the Blocked Process emails include a massive sql fragment. Is there anyway of truncating the sql fragment included in the email to a maximum length?