Home / server / Questions / 77865
In Process
GrZeCh
Asked: 2009-10-25 00:35:27 +0800 CST

SQL Server 2008 - SQL Mail and sender addres

  • 772

is there possibility to have procedure which sents emails from SQL Server 2008 where I can type sender e-mail address?

Thanks

sql-server

1 Answers

  1. In SQL Server 2008 use Database Mail, not SQL Mail to send email. SQL Mail is legacy & will be removed in future versions.

    You will first need to configure Database Mail

    Once a profile has been setup for Database Mail, use the sp_send_dbmail stored procedure.

    EDIT:

    It works fine for me when i use a different @from_address from what is specified as the email address in the profile. This address is only used when i don't specify a from_address. Code I used to send the email is below: 

    EXEC msdb.dbo.sp_send_dbmail 
@profile_name='nick '
, @from_address ='Nick Kavadias <[email protected]>'
, @recipients='[email protected]'
, @subject='this is a test message'
, @body='t.e.s.t m.e.s.s.a.g.e'

    A screen shot of my mail profile settings are below:

    alt text http://img91.yfrog.com/img91/1298/databasemail.jpg

    Is the mail being queued? Do you have any logs from your SMTP server?

    Check that there aren't any error in the database mail log table msdb.dbo.sysmail_event_log

    Failing that, check that it's not something the mail server is disallowing.

    • 1