Sending email using SQL Server msdb sp or by using extended stored proc

http://projectsmm.com/technet/mssql/dbmail/dbmail_setglobalprofile.shtml

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

extended stored proc in master database ( doesnt work for 64 bit system though )

http://www.datasprings.com/resources/articles-information/creating-email-triggers-in-sql-server-2005

http://dnavin.wordpress.com/2011/03/19/extended-stored-procedures/