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
3
votes
3 answers

archiveopteryx VS dbmail

I am after a database system to store my email messages (over 4 million now) which would allow me to search over emails easily programmatically, so far I only found these two, and alternative is come up with my own schemea and sync the IMAP/Pop3…
Max
  • 4,152
  • 4
  • 36
  • 52
3
votes
2 answers

How to include login information in an sql server mail?

I am working on SQL Server 2008. I have created a trigger on a table which will send a notification mail if the records are updated. I have included what is getting updated in body of the mail. Along with that I also want to include who has updated…
user2277333
  • 33
  • 2
3
votes
3 answers

Sql server Db Mail which can send mail for two or more queries

I want to send db mail , which contains the result of two queries, how do I make it happen? USE msdb EXEC sp_send_dbmail @profile_name = 'try01', @recipients = 'yyyyy@yyy.com', @subject = 'Table Values', @body = 'xxxxxxxxxxxxxx.', …
Bhaskar Mishra
  • 3,332
  • 7
  • 26
  • 36
2
votes
1 answer

Cannot Get DBMail to Work. Worked in the Past

SQL Server 2005 DBMail. I had all of this working, but then it just stopped. I tried starting over from scratch to no avail The surface area configuration tool has been used to make sure the procs in msdb are active. I've tried stopping and…
jtb
  • 347
  • 1
  • 2
  • 7
2
votes
1 answer

SQL Server 2005: Difference between SQL mail and DB mail

Ok. I know SQL Mail is less secure and old, but what are the real advantages and differences between the two? I read this article, which is pretty straight forward, but I was hoping to get someone to tell me why (if any) would you want to use SQL…
Fandango68
  • 4,461
  • 4
  • 39
  • 74
2
votes
2 answers

send dbmail on @@error from sql server 2005

I am trying to send database mail when error occurs inside the transaction.My setup for dbo.sp_send_dbmail is correct , when I execute the proc I do get an email within 1 min. However when I try to use dbo.sp_send_dbmail inside another proc within…
Zeus
  • 3,091
  • 6
  • 47
  • 60
2
votes
1 answer

Send email from SQL server for each row of a dataset

I have built a stored procedure for sending an email reminder to a set of employees each week. The SQL server agent runs a scheduled procedure each week that builds this weeks dataset of employees and then I need to have each of the employees…
defect833
  • 275
  • 7
  • 22
2
votes
0 answers

SQL Server 2005 DbMail not sending

I have a SQL Server 2005 DB Mail profile set up on my server that successfully sends a test email. However, when I queue an email in the msdb.dbo.sysmail_mailitems table, it does not ever try to send it. The status of the item stays at 0 (unsent).…
hofnarwillie
  • 3,563
  • 10
  • 49
  • 73
1
vote
1 answer

how can I set up my sql server to email me when databases are approaching max size?

I was working on an old project the other day over vpn for a client and found an issue where I was purging data off of the wrong PK and as a result their database was huge and was slow to return info which was causing our software to freak out. I…
TWood
  • 2,563
  • 8
  • 36
  • 58
1
vote
1 answer

How do I diagnose and fix "Error formatting query, probably invalid parameters, incorrect syntax" error?

I'm putting together a stored procedure that sends some query results attached as a CSV in an email. I'm testing the procedure and get this error: Msg 22050, Level 16, State 1, Line 2 Error formatting query, probably invalid parameters Msg 14661,…
Hiebs915
  • 666
  • 1
  • 7
  • 22
1
vote
2 answers

Returning query to an HTML table alert email with TSQL dbmail

I have a stored procedure that works like a charm, and i am really happy with it. In order to be perfect I just need it to do a little thing more. it returns nothing, if no parameter is met, or it just says "found one", if the select has somehing to…
questionador
  • 111
  • 1
  • 3
  • 12
1
vote
2 answers

DB Mail could not sent mail to the recipients because of the mail server failure in sql server 2012

I have tried to send database mail but the following issue occurs. The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2018-11-13T13:05:31). Exception Message: Could not connect to mail…
Vengat
  • 235
  • 1
  • 5
  • 16
1
vote
1 answer

A call to SSPI failed, see inner exception. DB Mail can't send email

My db mail suddenly stopped working, the error is: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2018-08-14T16:00:23). Exception Message: Cannot send mails to mail server. (A call to…
Mel Cuya
  • 25
  • 8
1
vote
1 answer

vb6 vs SQL script for DBMail to outlook, what's going wrong?

The following TSQL script works like a charm: declare @result as int declare @myID as int declare @sig as varchar(MAX) declare @MsgBody as varchar(MAX) declare @Attachments as varchar(MAX) set @Attachments = '\\the-SQL-servers-host\the-share-…
Harry A
  • 105
  • 1
  • 10
1
vote
0 answers

RC ignored - Failed to initialize sqlcmd library with error number -2147467259

I have an example query that I am purposely failing as the db and table doesn't exist as part of my test declare @nsql nvarchar(4000) ,@rc int set @rc = 0 set @nsql = ' EXECUTE msdb.dbo.sp_send_dbmail @subject = ''test sub'' ,@recipients =…
jay
  • 11
  • 3
1
2 3 4