Tuesday, 28 September 2010

Send Email from SQL server

exec master.dbo.xp_sendmail
@recipients ='myasin@clash-media.com',
@subject = 'testing SQL Server Emails',
@message = 'Free space on Z Drive has dropped below 2 Gigabyte'

will get error message if on 64-bit version:
"SQL Mail does not work with the 64-bit version of SQL Server"

Instead Can use:
Profile Name is the setting in:

[database] -> Management -> Database Mail -> Configure Database Mail


EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'SQLServerDatabaseMailProfile',
@recipients = 'muhammad.yasin@clash.com',
@body = ' is scheduled to be renewed in 120 days - GET TO WORK!',
@subject = 'testing by yasin'

No comments:

Post a Comment