I definitely agree with what a few people said above, there should be at least a few armed, trained security guards at middle and high schools. Even though there are already some schools with an armed (single) resource officer, one person can't prevent everything. Here's a short film I thought would add onto this topic. (definitely not for the squeamish)
http://www.youtube.com/watch?v=pZUFsAbnMbA