Last week I was trying to troubleshoot some activation stored procedures in Service Broker.  One nice thing about this framework is that it logs activation procedure errors in the SQL Server error log, since activation is not an interactive experience.  You will see error messages like this: The activated proc dbo.procedure_name ...