Any options for some sort of event driven queue - ie, when a message is received, SQL will call a stored proc?  Kind of like a trigger I suppose.

Sounds very much like MSMQ - I suppose it does make sense to store it in the DB.  I'm yet to find the time to actually play with SQL 2005   Of the hundreds of articles I have read about it, this is the first to talk about the service broker - nice to know it exists!