SQL Advanced: SQL server extended SP to send UDP messages

If built carefully (considering the security issues but also the performance issues), the SQL extended stored procedures can be used successfully in solving critical complex problems. Here's an example on how can you "announce" that a table has changed:

http://www.codeproject.com/useritems/extended_stored_procedure.asp