forgive my ignorance but do you know how to use the drill through to actually see what causes the alerts? if so should of got the tsql in question which caused the error.

if I remember correctly spotlight doesn't store the session information for the alert unless you modify it's alert storage settings from default so trying to get the information now might be tricky