The database-mail tag has no wiki summary.
1
vote
1answer
97 views
Sending a mail using DB2's Proceude UTL_MAIL
I'm trying to send mail from DB2 using the procedure UTL_MAIL.
I'm using the DB2 Express Edition 10.1.
First I was getting the error of SMTP Server.
After using the below command,
update admin cfg ...
1
vote
1answer
127 views
SQL Server Database Mail - Why can't I run an execute against xp_sysmail_activate?
SQL Server 2008 R2 Standard x64
I can't send e-mail from this SQL Server (out of MANY that are configured pretty much identically AFAIK). I have created the mail profile and account. However, any ...
2
votes
1answer
204 views
Can you have multiple Oracle ACL files?
I have an application which needs to send emails through Oracle triggers. I understand that in Oracle 11g you must have an ACL file to grant certain schemas access to the network. My plan was to ...
2
votes
2answers
323 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 ...
1
vote
1answer
161 views
Logshipping alert emails are being sent out while there is no error
I have logshipping setup with a Primary and a Secondary, and this has been working fine for a long time. Yesterday I started reveiving these emails:
The log shipping primary database ...
0
votes
1answer
295 views
Database Mail Issue
I am getting a strange error randomly when i try to send emails using database mail using SQL Server.
The mail could not be sent to the recipients because of the mail server failure.Exception ...
3
votes
2answers
249 views
sp_send_dbmail fails when mailing queries, but no error returned, query just hangs
I have an issue SQL Server 2005.
sp_send_dbmail fails when mailing out with the result of a query (inline or attatchment).
No error message is given / reported, the query just keeps executing but ...
3
votes
1answer
325 views
Database Mail to Distribution List
I have a SQL Server 2005 which I have configured the database mail to setup monitoring alerts and notifications. I also create a email distribution list containing a couple of emails. The thing is ...
2
votes
2answers
635 views
how to use database mail from SSIS
I try to use gmail in database mail. I have no problem to send out email from it. But how I can configure my send mail task to send out email by using database mail. Thanks
2
votes
1answer
681 views
SQL Server Database Mail failing to send emails with error Sender address rejected: Access denied
The environment is a 2 node 2008 SQL Cluster. The first node was running fine but after failover to the second node Database Mail no longer can send emails. I am using Basic authentication.
The ...
1
vote
1answer
339 views
Elegant way of sending e-mails with Service Broker
Is there an elegant way for sending e-mails using a Service Broker service/queue?
I want to setup an EVENT NOTIFICATION for SQL Server, and I'd like to send e-mails to operators for each message on ...
2
votes
2answers
279 views
Replace the server name in email sender address when sending email from SQL Server 2008
I'm sending emails directly to Microsoft Outlook accounts from SQL Server 2008. Everything is fine, email was sent. Only problem is that in the header of the email the SQL Server name is embedded.
...
