Stack Overflow
Stack Overflow

Questions tagged [database-mail]

is a component of Microsoft SQL Server for sending e-mail messages.

Database Mail is a component of Microsoft SQL Server for sending e-mail messages directly from the SQL Server Database Engine.

95 questions
0
votes
1 answer

Limiting DatabaseMail sending rate

We are using DatabaseMail of SQLServer to send our mails. But our e-mail server provider is allowing us to send 5 e-mails per second, the other ones are simply rejected. I need to figure out throttling DatabaseMail.
timu
  • 828
  • 7
  • 20
  • 40
0
votes
1 answer

sp_send_dbmail not sending Email when row inserted from Website

I have a table in which if row is inserted I send a notification email. It works fine if I insert a row manually using SQL Server Management Studio, but fails if I insert a row from Web Interface. Jsut can't figure out why it would fail with insert…
AM0
  • 165
  • 2
  • 4
  • 20
0
votes
1 answer

Database mail messages are being queued but they are never delivered

I have database mail configured properly, it has been working all along but then suddenly iam getting the error below in the description column of the sysmail_event_log view database msdb. Any idea why i could be getting this error message? Bellow…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
0
votes
2 answers

Configure database mail settings

How can I configure database mail settings and send the mail from the database in Sharepoint created default database instance as i can not find where to configure the database mail settings from the management after login sa user.
Paresh
  • 3,659
  • 6
  • 27
  • 32
0
votes
2 answers

How to use SQL Server Transaction inside T-SQL TRY...CATCH block

I have sample T-SQL code below, BEGIN TRY BEGIN TRY BEGIN TRANSACTION RESTORE FILELISTONLY FROM DISK = 'D:\Backup\MyDatabase.bak' GO ALTER DATABASE MyDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
0
votes
1 answer

Can we attach the result produced by query in .txt format in sql?

Is it possible to attach the result produced by query in .txt format while sending mail in sql ?
viji
  • 119
  • 2
  • 3
  • 12
0
votes
0 answers

SQL Server 2005 Database Mail Error: exception

Been trying for weeks now to get this set up and have had no luck. Have tried changing accounts and profiles, added databasemailuser permissions to mine and several other accounts, but still get this message 1) Exception Information …
enderv
  • 203
  • 1
  • 2
  • 7
0
votes
3 answers

SQL Execute per each result row

I've been googling around for a bit but I can't seem to find an answer to this. I'm trying to use the Database Mail in SQL Server 2005 in a stored procedure where the idea is to send separate mail for each row in a query, each mail depending on an…
Kahn
  • 43
  • 1
  • 7
0
votes
0 answers

Select the Database mail account from Database Profile for sending mails in Sql Server 2008

I was trying to send mail using Database Mail in Sql Server 2008 It works fine when i use individual profile, but my scenario is different. Here what i want to achieve. I have a database profile which contains multiple accounts like A, B, C…
Abbas
  • 4,948
  • 31
  • 95
  • 161
0
votes
2 answers

Database Mail - Mail configuration information could not be read from the database - No Exception

I've been trying for hours to get Database Mail working on SQL Server 2008 R2 and have reached what seems like a dead end. I have completed the Database Mail Configuration tool, made sure that SQL Brower is turned on and followed all the steps in…
Michael Rodrigues
  • 5,057
  • 3
  • 25
  • 51
0
votes
2 answers

Sending E-Mail via DatabaseMail with C#

How can I send e-mails using Database Mail (which is integrated in SQL Server) in C# ? I couldn't find a useful article or something which can help me thoroughly.
Tarik
  • 79,711
  • 83
  • 236
  • 349
0
votes
1 answer

Database Mail SQLServer 2008 and Outlook Sent Items folder

I have configured Database Mail for SQLServer 2008, I can send emails via our SMTP server, which use Exchange. The problem is that I want to store the sent messages in the Sent Items folder of the corresponding user, but the system is not doing…
Daniel Salazar
  • 53
  • 1
  • 5
0
votes
1 answer

SQL Server 2008 - Different ways of sending an email and dependencies

What are all the different ways (in code and from the GUI) which SQL Server 2008 can be used to send emails? For each way please state any dependencies e.g. an Outlook profile or Database Mail (enabled and configured). So far I know of the following…
Chris Cannon
  • 1,157
  • 5
  • 15
  • 36
-1
votes
1 answer

How can I find the source of a specific, SQL Server Database Mail-generated message?

A user has requested they be removed from an email notification sent out by our database server, but I can't find the object responsible for the email! I know the sender, receiver, subject, body, and time of day. I know that Database Mail is sending…
K r
  • 17
  • 7
-1
votes
1 answer

SQL Server, Database Mail not working once published on IIS

I am trying to setup the SQL server to send automatically an email every time a new record is inserted in one table. I have setup the Database Mail and it is working perfectly when I run the app locally from Visual Studio. But at soon as I publish…
Julien7377
  • 475
  • 4
  • 15
1 2 3 4 5
6
7