Using stored procedures allows you to have multiple actions attached to a single trigger.

This story continues at http://www.databasejournal.com/news/article.php/3428231