Stack Overflow
Stack Overflow

Questions tagged [dbmail]

DBMail is an open-source project that enables storage of mail messages in a relational database. Currently MySQL, PostgreSQL, Oracle, and SQLite can be used as storage backends. Commercial development and support is also available.

DBMail is an open-source project that enables storage of mail messages in a relational database. Currently MySQL, PostgreSQL, Oracle, and SQLite can be used as storage backends. Commercial development and support is also available.

FROM: http://www.dbmail.org/

54 questions
1
vote
2 answers

sql server 2008 dbmail error sp_send_dbmail - cannot insert null value into 'last_mod_user' in table sysmail_mailitems

Our dbmail got hosed and I'm trying to resolve the issue. I've recently recreated sp_send_dbmail, but am not getting an odd error regarding a null value in last_mod_user column in table msdb.dbo.sysmail_mailitems (error 515)
mson
  • 7,762
  • 6
  • 40
  • 70
1
vote
0 answers

SQL Server 2014 dbmail won't send attachment over 15MB, file size limit set to 60 MB

I have an automated e-mail that goes out and will sometimes have an attachment, this has been running for over 3-4 years now with no issue, until now. Up to now, attachments were maxing out at just over 14MB, but the other day we had two that failed…
BIrish
  • 29
  • 4
1
vote
1 answer

How to attach a file to an email using SQL stored procedure?

Can't seem to find much information about how to attach a file that's been stored as a BLOB as part of an email. I know you can attach files from the file system (C:\temp...) to email that are being setup in DBMAIL or custom stored procedures.…
aimlessWonderer
  • 205
  • 1
  • 7
  • 17
1
vote
1 answer

Send dbMail from SQL Server 2000 with Tabular structured data?

I am trying to achieve this kind of formatted data from my select statement and have it send via database mail in SQL SERVER 2000. I know how to do this in SQL 2008. Column1 | Column 2 ------------------ Value 1 | Value 2 Value 1 | Value 2 Value 1 |…
Zeus
  • 3,091
  • 6
  • 47
  • 60
0
votes
0 answers

Send email on RazorSQL

Is there any way to be able to send an email or some similar feature like with the sp_send_dbmail function in RazorSQL? I was trying to look for similar functions or characteristics but I found zero information on this case
Wuro
  • 1
0
votes
0 answers

Failed to execute msdb.dbo.sp_send_dbmail

I'm getting this error: Msg 22050, Level 16, State 1, Line 0 Failed to initialize sqlcmd library with error number -2147467259. My code is: IF EXISTS (SELECT * FROM [StagingMX].[dbo].[_CVA] WHERE DATEDIFF(DAY, [Completion time],…
Raúl Vélez
  • 1
  • 3
0
votes
0 answers

get query result with trigger

get query result with trigger Hello, I want to get the code in the line when insert, I will use the code I received in a query and create a table, Then I will send this table to the interested parties by e-mail, I created a trigger, I got the code…
Ilhan Ates
  • 11
  • 3
0
votes
0 answers

How can I attach a file name containing a / with sp_send_mail?

I have a query that sends an email to me each month for the previous month's data that we receive. I'd like to include the last month and current year in the filename. I got the month and year to work but when I try to show them in the filename,…
Hiebs915
  • 666
  • 1
  • 7
  • 22
0
votes
0 answers

SSMS Database Mail not sending to multiple recipients anymore

We have a job in SSMS which runs daily and goes through steps that send out emails to employees with different reports. Recently, one of the queries stopped sending out emails and I'm not sure why.. I wasn't the one who made this query and I'm not…
Lucas Talebli
  • 41
  • 1
  • 6
0
votes
0 answers

Why doesn't a SQL trigger have permissions to use e-mail?

I have a vb.net 4.6.1 Windows Forms application. In it, a SQL stored procedure is called. That stored procedure then deletes a record from a table. This is all working fine. That table has a delete trigger that sends an e-mail. That trigger…
boilers222
  • 1,901
  • 7
  • 33
  • 71
0
votes
1 answer

How to send an email on finding bad data in a table in sql server

I have below EmployeeData table and due to some known reasons BAD data is getting inserted and i am working on code fix, but meanwhile i want to check for bad data until the fix is deployed. If you observe John has 1 for both Active and IsEmpTermed…
Learner
  • 139
  • 1
  • 9
0
votes
1 answer

SQL Server Mail senging error using sp_send_dbmail on gmail server

I am setting up a trigger based mail notification and while using it, I am also getting error. The Profile setup is as bellow: EXECUTE msdb.dbo.sysmail_add_account_sp @account_name = 'TestMailAccount', …
Harsh Shankar
  • 506
  • 5
  • 16
0
votes
1 answer

SQL Server: modifying how the email message is displayed

Thanks to the help I received, I was able to modify my stored procedure to send the email below when a condition is met. Name Start Date Doe, John 0012-12-16 But now I need to modify my stored procedure again to make the email look like…
LucasC922
  • 167
  • 9
0
votes
0 answers

How do I compile SQL email but not send?

In SQL Server, it's possible to send an email via Outlook. I want to compile an email but have it automatically sent. The code below automatically queues the email and sends to the recipients. I need to make adjustments on the email before sending…
learningSQL
  • 3
  • 1
0
votes
1 answer

SQL server stops sending db mails in sql server 2014

We are facing the issue with DB mails in sql server 2014. Suddenly, it stops sending emails to users stating UNSENT status in msdb.dbo.sysmail_allitems. Please help.
Girish
  • 11
  • 3
1
2
3 4