Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results, and can also include files from any resource on your network. Database ...
1
vote
0answers
90 views
Troubleshooting Database Mail issues and Service Account permissions in SQL Server
I am having difficulties troubleshooting a Database Mail issue. When I try to stop and start the service using sysmail_start_sp and sysmail_stop_sp, I see a critical error in the Administrative Logs ...
2
votes
1answer
82 views
SQL Server Alert - Description (None) [closed]
For every system Alert defined to send an email, we receive a 2 alerts with the following bodies. How do I stop the message with the empty (None) description?
Empty Alert
SQL Server Alert System: ...
2
votes
2answers
303 views
Securely Send Database Mail via an Insert Trigger
I have spent about 30 hours so far trying to get sp_send_dbmail to work. I finally got SOMETHING to work, but I have serious doubts as to its security. I would like know a method which is better yet ...
4
votes
1answer
141 views
Denied access sending dbmail while impersonated under a login with sysadmin privilege
This question is similar to but not the same as this.
I created a stored procedure and set it to execute under the context of a sysadmin login (let's called it sys1). For testing purposes, I only ...
1
vote
2answers
604 views
Create job to send alert using sp_send_dbmail when table value greater than x
PROBLEM
The SMScounter.Counter is used to accumulate usage from a service. The service has a programmatic cap of 1000. I would like to alert users when this cap is breached.
TABLE CREATE
CREATE ...
5
votes
1answer
738 views
Trouble With Database Permissions for sp_send_mail
I am trying to send database mail but I am getting EXECUTE permission denied on the object 'sp_send_dbmail' database 'msdb', schema 'dbo'.. I code I am running is as follows:
SELECT SUSER_NAME(), ...
3
votes
3answers
1k views
Unable to get DBMail working on SQL Server 2005
I have SQL Server 2005 SP3 (4053) running on a Windows Server 2003 R2 virtual machine. When trying to send a test dbmail message, either from the SSMS GUI or using sp_send_dbmail, I get the ...
1
vote
0answers
133 views
Pros and cons of using DBMAIL [closed]
What are the pros and cons of using dbmail specifically for handling IMAP folder?
Current engine is Dovecot 1.2.15 running Linux 2.6.32.2 SMP x86_64 GNU/Linux/Debian 5.0 alias Lenny
and this is ...
4
votes
1answer
1k views
Is there a way to force sp_send_dbmail to use ANSI, or to not include the Unicode prefix?
This is pretty trivial, but if someone has the answer handy, I'd appreciate it.
I use the msdb..sp_send_dbmail sproc as a lightweight way to distribute simple reports. This often entails producing a ...
