SQL Server (T-SQL)

Browse by Tags

• Mail from a stored procedure in SQL 2005

  Code to send mail from a sql 2005 stored proc will look something like this: declare @body1 varchar ( 100 ) set @body1 = 'Server :' + @@servername + ' My First Database Email ' EXEC msdb . dbo . sp_send_dbmail @recipients = 'steve@4penny.net' , @subject... Posted Feb 02 2007, 04:30 PM by Steve Gray with | with 3 comment(s) Select Tags... SaveCancel Filed under: sql mail [Edit Tags]