send an email by way of SQL

EXEC master.dbo.xp_sendmail @recipients = @peeps, @message = @msg, @subject = 'Whatever'

 
 

...this is an example of sending an email via SQL! http://msdn.microsoft.com/en-us/library/aa260697%28v=sql.80%29.aspx has more on this.