January 6, 2009 at 9:09 am
Dear friends,
Please let me know how to send mail automatically in sql server?
regards,
K.Kamesh
January 6, 2009 at 10:59 am
Look up sp_send_dbmail in books online.
January 6, 2009 at 11:15 am
DBMail is built into SQL 2005 and 2008. If you are using a version before that, it's a bit more complex.
Assuming you're using 2005/08, you'll need to enable the use of DBMail. That can be done with the Surface Area Configuration Tool, found under SQL Server on your Start Menu in Windows, or can be done with commands.
Once you've enabled it, you'll need to set up a mail profile. You can do that from the Management tab on the server in Management Studio.
Then use msdb.dbo.sp_send_dbmail to send e-mails.
Details on each of these steps can be found in Books Online and/or MSDN. If you need help with any of them and can't quite get it from those sources, ask here and we'll be happy to help you out.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 7, 2009 at 2:40 am
How to send e-mail without using SQL Mail in SQL Server
Sending SMTP Mail using a Stored Procedure
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply