[dba-SQLServer] Another good one from Francisco

Hello Susan and Francisco
I wish I know about blat a few years ago when I was struggling to get
outlook installed on a SQL Server.

With 2005 though, is there some hidden benefit that I am missing in  your
blat code, over the following code.

I have met quite a few people of the the last ten years that do not like to
use SQL Sever mail, but I have used it with never one complaint for close to
ten years now.  For me it gives me very quick to implement email facilities.

Thanks for blat,

Mark


EXEC msdb.dbo.sp_send_dbmail
     @profile_name = 'Server4DBMail',
 @recipients = 'mark.breen at gmail.com',
     @query = 'Select * from MyTable',
     @body = 'Hello World, here is the contents of the table',
     @subject = 'More SQL Server email',
     @attach_query_result_as_file = 0
 ;


2009/6/23 Susan Harkins <ssharkins at gmail.com>

> <http://www.devx.com/dbzone/Article/42178>
>
> Sending E-mail from SQL Server 200X
>
> Susan H.
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>