The Sql2Growl project is an application to send Growl notifications from SQL Server. It consists of a database part (Service Broker queue and stored procedures) and a C# NT Service part. Using a procedure you can add notifications to the queue. Instantly the NT Service pulls them and forwards the notification to Growl.
As soon as the project is in a state I am happy with I will post more information.