Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

email in sql server

Is there anyway to tell the status of an email sent threw sql server?  If I query sysmail_allitems it shows an email as being sent, but i have a supplier that is saying they are not getting it.  So I'm wondering is it actually sent (ie. did it leave our exchange server).  Does this sent status mean yes, or does it mean it left sql server only?
0
Fraser_Admin
Asked:
Fraser_Admin
1 Solution
 
indianguru2Commented:
It means it has left your SQL Server.
If your exchange denies routing of the mail, then it would show an error in the error log of database mail.
You should check your Exchange setting Junk Mail Filter.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
you have to check the exchange server
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now