[Note: I assume you have set up and configured Database Mail. If not, check this link Database Mail Configuration Stored Procedures to use various stored procedures required to configure Database Mail. As an alternative, you could also use the SQL Server Surface area configuration tool to configure Database Mail]
Use the following script to send a mail from your Sql Server
USE [YourDB]
EXEC msdb.dbo.sp_send_dbmail
@recipients = 'admin@xyz.com; xyz@xyz.com; pqr@xyz.com',
@body = 'Just testing the mail',
@subject = 'Sending Mail using Database Mail' ;
GO
Did you like this post?
|
|
||
|
|
|
|
|
subscribe via rss |
|
subscribe via e-mail |
|
print this post |
|
follow me on twitter |
About The Author
comments
9 Responses to "How to send an email using SQL Server 2005"Thanks, dude - this was exactly what I was looking for! Much appreciated...
Chris
Thanks a lot for this starter kit!
Thanks for your help, it works perfect. But If you let me a little comment, one parameter is missing:
USE [YourDB]
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Your Profile',
@recipients = 'yourmail@yourdomain.com',
@body = 'Just testing the mail',
@subject = 'Sending Mail using Database Mail' ;
GO
@profile_name is the name of the profile that you've setup on DataBase Mail before try to sending
mails.
Hope this helps.
Once again thanks for your help and advice.
Makron
Thanks for that input Paul.
Yeah, thanks!
Can Anyone Tell me "how to send an audit report generated by auditing tool( Which i am developing) to a mail address automatically after span of 1 month"
You would have to create a job using SQL Server Management Studio or using T-SQL to send emails automatically after a given period of time.
I also want to know how make this run every day and send email alerts with the query results
Priyab: Some links to help you out
http://support.microsoft.com/kb/908360
If you intend using a trigger
http://blog.netnerds.net/2008/02/create-a-basic-sql-server-2005-trigger-to-send-e-mail-alerts/
Post a Comment