Skip to main content

Questions tagged [database-mail]

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 files from any resource on your network. Database Mail is designed for reliability, scalability, security, and supportability.

Filter by
Sorted by
Tagged with
2 votes
0 answers
345 views

Database Mail connection to exchange - Resets and timeouts

I am trying to send the results of a query in an email, and each time it takes longer than 5-10 minutes for me to recieve the message. The actual relay from Exchange takes less than one minute, but ...
msgisme's user avatar
  • 664
0 votes
3 answers
3k views

sp_send_dbmail with multiple reply_to addresses

I got this error when I specified multiple email addresses in reply_to The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 7 (2014-08-...
BobNoobGuy's user avatar
2 votes
1 answer
2k views

Enable Agent Database Mail - TSQL

I have several new servers that need Database Mail configured on them. I found the TechNet article describing how to add the profile and account via procedure calls, but is there a way to enable ...
Dave Johnson's user avatar
2 votes
0 answers
3k views

Database mail "Mailbox unavailable. The server response was: 5.7.1 Unable to relay for..."

I am getting this error on a named instance. I set up the account and profile. It is pointing to our internal anonymous smtp server. The IP address has been allowed to relay on the SMTP server. ...
Jeff's user avatar
  • 121
0 votes
1 answer
404 views

Sending one email when all jobs completes successfully

I need to create backup jobs over several instances, I wonder if there is any way to send a single notification via mail only when jobs from all instances completed successfully.
Michael Cherevko's user avatar
2 votes
2 answers
6k views

Database Mail not sending

I'm trying to send email using the DatabaseMail on SQL Server 2008, I can see my emails setting in the msdb.dbo.sysmail_unsentitems But they just sit there, I get no error messages. I've checked ...
EricGuesting's user avatar
1 vote
1 answer
144 views

How to configure database mail in sql server 2012 [closed]

when I configure the database mail it is showing the following error, what it means ?
udhaya's user avatar
  • 13
2 votes
0 answers
411 views

SQL Server Database Mail Log is flooded with errors (20-30 per second) when mail server goes down

We're using SQL Server 2005. Every so often our mail server goes down, and when this happens, as soon as our SQL code tries to send dbmail, the Database Mail Log has an item which looks like this: ...
Nat H's user avatar
  • 21
2 votes
2 answers
26k views

Problem sending an attachment using dbo.sp_send_dbmail

I am trying to send an attachment using dbo.sp_send_dbmail. I can't do this I get the error Attachment file \VMName\ListTEAM\LCPP_CP.pdf is invalid. Just some quick things that I have checked. I ...
Rascal of the North's user avatar
2 votes
1 answer
4k views

Error checking with sp_send_dbmail

This question is kind of multifaceted. First, what I'm trying to actually accomplish: I am in an environment where there is not really heavy data validation on inputs. So there is lots of opportunity ...
liver.larson's user avatar
1 vote
2 answers
13k views

How to delete list of email addresses from MySQL database?

I have a list of invalid email addresses parsed in the following format; There are roughly 1500 invalid addresses, and I need to remove them from my myBB users. What SQL query can I run to remove ...
Jake's user avatar
  • 11
10 votes
1 answer
5k views

What permissions does the service account need to use database mail?

I have an SQL Server 2012 instance running under a managed service account. I've configured database mail with one account and am trying to send a test email, but I'm getting some errors in the server'...
Mansfield's user avatar
  • 1,031
1 vote
1 answer
1k views

Use SQL Server Database Mail with Amazon SNS

Is it possible to configure SQL Server 2012 Database Mail (hosted on EC2) with Amazon SNS? I'd love a single place to manage all alert notifications and their subscribers in SNS, but Database Mail ...
Alex's user avatar
  • 191
9 votes
2 answers
15k views

How to select the mail profile in a sql agent job

I have several mail profiles configured on sql agent, how can I choose which of these profiles gets used for sending out notifications on a specific sql agent job ?
nojetlag's user avatar
  • 2,897
2 votes
1 answer
366 views

Can SQL Server 2008 R2 get email name resolution from Office 365?

We just moved from an on premise Exchange server to Office 365's Exchange Online. My question is, is there any way to still get email name resolution from Office 365? I have many stored procedures ...
MAW74656's user avatar
  • 302
3 votes
2 answers
2k views

Configure Email to be sent on restoring a database

Is there a way to configure Email in SQL Server such that an Email is sent when a particular database is restored.
user824910's user avatar
56 votes
3 answers
168k views

How can I see the current Database Mail configuration?

Our SQL Server (2008) instance is configured to send mail and everything is working correctly, but I can't figure out how to view the existing configuration, in particular the SMTP server. From SSMS ...
Alex's user avatar
  • 663
0 votes
1 answer
1k views

Query mail logs for xp_sendmail

Using SQL Server 2008, I can query sysmail_log and other tables to see the results of sql emails. Is anything remotely similar available for querying email logs in SQL Server 2000?
mg1075's user avatar
  • 755
1 vote
3 answers
16k views

Database Mail sending functionality not working on local system

I am using Database Mail functionality to send mail from a SQL Server 2008 database via following stored procedure execution: EXEC sp_send_dbmail @profile_name = 'MyProfile', @...
Sukhjeevan's user avatar
1 vote
1 answer
3k 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 ...
Raj Wadhwa's user avatar
5 votes
2 answers
4k 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 ...
SomeGuy's user avatar
  • 2,013
3 votes
1 answer
512 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: '...
BrandonMoser's user avatar
2 votes
2 answers
8k 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 ...
user1578653's user avatar
2 votes
2 answers
2k 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 ...
Chiramisu's user avatar
  • 283
4 votes
1 answer
1k 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 ...
deutschZuid's user avatar
5 votes
3 answers
22k 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 ...
scott_lotus's user avatar
2 votes
1 answer
3k 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 SERVER....
edosoft's user avatar
  • 143
1 vote
1 answer
3k 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 Message:...
Ashish's user avatar
  • 727
4 votes
3 answers
929 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 ...
Jonno's user avatar
  • 141
5 votes
1 answer
4k 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 ...
mvillegascuellar's user avatar
3 votes
2 answers
6k 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
user1188125's user avatar
3 votes
1 answer
5k 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 ...
user8014's user avatar
2 votes
1 answer
3k 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 ...
ivanmp's user avatar
  • 2,323
9 votes
1 answer
5k 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(), ...
Kyle Brandt's user avatar
  • 2,345
3 votes
2 answers
12k 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. I'...
user avatar
3 votes
2 answers
2k 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 ...
dmmaxwell's user avatar
6 votes
1 answer
5k 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 stored procedure as a lightweight way to distribute simple reports. This often entails ...
Jon of All Trades's user avatar

1 2 3
4