Annotations for "sp_send_dbmail (Transact-SQL)" topic.Tue, 26 Sep 2017 22:36:07 Zhttp://technet.microsoft.com/en-us/library/ms190307(v=sql.110).aspx#CommunityContent
ktrockSlightly wrong role for securityPermissions should read "Execute permissions for sp_send_dbmail default to all members of the DatabaseMailUserRole database role in the msdb database."Tue, 11 Mar 2014 19:27:30 -0700http://technet.microsoft.com/en-us/library/ms190307(v=sql.110).aspx#CommunityContent
bnordbergI like to add a IFIF@tableHTML isnotnullBeginEXECmsdb.dbo.sp_send_dbmail ...ENDThu, 08 Aug 2013 17:23:05 -0700http://technet.microsoft.com/en-us/library/ms190307(v=sql.110).aspx#CommunityContent
Randy PitkinMSDN in total / Where is my well formed parameters and datatypesThe arguments used to be in a table which allowed me to script the execution. Argument | Data type | Description Please?This costs me almost an hour every time I want to implement a procedure for a new version or new customer/Mon, 24 Jun 2013 21:29:01 -0700http://technet.microsoft.com/en-us/library/ms190307(v=sql.110).aspx#CommunityContent
Maurizio_62SQL 2008 xp_send_dbmail time outHello,I have a problemwithsending e-mailwith xp_send_dbmail.I havecorrectly configured accountand userprofile,the service worksbut leavesthe e-mailsinthe queue until thetimeoutThepc is in corporate domain,the operating systemvista 64bitsql2008 64bit,logged in asadministrator insqland PCThe mailsare queuedbut not sentandthe sendingfailsdue to timeoutThanks for the help MaurizioFri, 03 May 2013 14:04:51 -0700http://technet.microsoft.com/en-us/library/ms190307(v=sql.110).aspx#CommunityContent
TEAMERemail expiry?Would have been nice if email_expiry_date was a parameterFri, 21 Dec 2012 18:31:14 -0800http://technet.microsoft.com/en-us/library/ms190307(v=sql.110).aspx#CommunityContent
Feridun Kadir MCT@@ERRROR should Be @@ERRORThe variable has one too many Rs.Wed, 24 Oct 2012 14:15:20 -0700http://technet.microsoft.com/en-us/library/ms190307(v=sql.110).aspx#CommunityContent
DeadZoneWhen will we be able to attach query results as ANSI?The old xp_send_mail had a parameter (@ANSI_Attachment) to instruct SQL Server to attach the results of the query as an ANSI file. This is not possible with this "new and improved" version. When will we be able to attach ANSI files?!?Thu, 04 Oct 2012 14:56:00 -0700