Is it possible to send mails from Sql Server installed on a Stand-alone computer? If not, what are the requirements?
Kindly let me know.
Rgds Mohan Kumar VS
asked Sep 12, 2011 at 12:07 AM in Default
Yes, it is possible. You should Enable Database Mail from SQL Server Surface Area Configuration for Features - Start Menu->SQL Server 2005->Configuration Tools->SQL Server Surface Area Configuration for SQL Server 2005, probably something similar for SQL Server 2008, SQL Server 2008 R2 and Denali (you don't mention your version, so I'm assuming 2005 or later)
You can then send mail from a stored procedure using stored proc msdb.dbo.sp_send_dbmail
That is documented here: http://msdn.microsoft.com/en-us/library/ms190307.aspx
answered Sep 12, 2011 at 12:22 AM