.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Database Mail - How to clear queue list ?

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server

Hi Experts,


i had a job on my client database which is running every 3 minutes to send out all my mail item list using Database Mail.

This job will automatically send out email which is retrieve from one of my table (DocumentQueue).

So whenever user click "Email" button on my system, system will add record on my table (DocumentQueue)

and every 3 minutes my job will started to send out all email in DocumentQueue which is not being send.


What my problem is... the recipient on my table in the wrong format, ie: admin@google.com;stone.wu@g;

And this email is being send on 09:00.

It keeps sending email every 3 minutes...

on the 1st 10 minutes the errors on sysmail_log was : 

"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-10-04T09:28:00). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.). )"

and after 10 minutes the errors was :

"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-10-04T12:42:00). Exception Message: Could not connect to mail server. (An operation on a socket could not be performed because the system lack

View Complete Post

More Related Resource Links

Database mail - Test Mail is put in the queue with status as "Unsent"



I am having problems in sending mail. It was initially working but suddenly after restarting few services of sql server, the sending of the mails have been stopped.The test mail with the same credentials which worked earlier is now failing.

Surprising thing is that I cant find any data in the sysmail_log .... but all these mails are there in the queue with status as "Unsent"

I checked for all DB mail related services like

1. reconfigure of db mail

2.  dbo.sysmail_help_status_sp (status is STARTED)

3.SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb' (STARTED)



Is there any services to be run other than these, or anything else to be done??  Will be grateful if someone can help me on this..


Thanks in advance..



SQL and Outlook: Enable Database Access and Updates Through Exchange and Any E-mail Client


Using Microsoft technologies, you can insert, edit, query, and delete database entries using any e-mail client such as Hotmail, Outlook, Yahoo, or even WAP phone. While e-mail is certainly a powerful and widely used tool, it is usually not integrated with an application for performing any tasks other than sending reminders. The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.

Alok Mehta and Daniel Williams

MSDN Magazine January 2002

E-Mail Alerts for users on Task List


Is there any way to send e-mail alerts to a specific user wihtout assigning them the task or having them subscribe to the list.

It's a Task List on WSS 3 on Win2k3 Enterprise'


SharePoint List with Hyperlinks Stored in a Database


To all,

I need to display a List of Hyperlinks that are stored in a database. I want it to be a SharePoint List so it can be Indexed and Search properly in SharePoint.

SharePointSite Table - Columns:SiteName(nvarchar(256)), URL(nvarchar(256))

Example: Acme Foods, http://www.acme.com

I need a List that shows:

Acme Foods and is a clickable hyperlink  to http://www.acme.com

What is the best way to get access to the data and feed it to a List and then host it on a Site landing page?

This is meant to be a directory of Site Collections. We have 175 Site Collections that host our customers Report Libraries.



Modify Subject line of Notification e-mails sent by Database Mail

Hello All, I am using database mail for SQL Server Agent Job notification.  It is working just great. However the e-mails that I receive have a specific format of subject line as below. SQL Server Job System: 'TEST' completed on \\Server_Name I wanted to see if I can modify this to send e-mails with this subject line. SQL Server Job System: 'TEST' completed on <Server_Name> Is this possible?  If so can someone help me with the steps? Thanks.

does SPD support filtering of the mail title/body we send to a list/library?

for example, if we send a mail with the title of "%hostname% %ipaddress%" to a list. can SPD WF filter the title and get %hostname% to a new variable? the reason to ask this is i want to send a well-formated mail to sharepoint and the automatical WF can recognize the change of the list items and update the relevant columns by the filtered content from mail title or body. thanks!

how to in Insert database NULL if drop down list item is not selected ?

hi,   on my aspx I have the below DDL   <asp:DropDownList ID="ColorDDL" runat="server" DataSourceID="ColorObj"                                                 DataTextField="Size" DataValueField="BustId" Width="150px"                                                 AppendDataBoundItems="True">                                                    <asp:ListItem Value="-1">(Optional)</asp:ListItem>                             &n

How to export data from a sharepoint list to a SQL database

hi, is it posible if i add some data in a sharepoint list that i can export these data to my sql server tables. or if i create a dataview for exapmle from databse A in SPD to use in my wss3 site and then export it to database B in sql server? thnx

How to create field in the list that shows Person's e-mail of Person selected in other field?

There are nor web-parts allowed, neither any server-side code too.

how to create a list order and unorder using database

how to create a list order and unorder using database

Database Mail configuring the maximum mail size (not attachment 'MaxFileSize')

Hi can anyone tell me if it's possible to configure the maximum size of an email when using database mail?  I know it's possible to use sysmail_configure_sp to set 'MaxFileSize', I want to prevent an email being sent the size of the body of the email is very large. In my case the body is based on a query result set inserted as html. Thanks      

Database Mail error

Hello I am new to SQL Server 2008. I am upgrading from 2000 to 2008 and currently working on Database Mail. I can send a test mail to say an email address like abc@xyz.com If i create an operator with the above email address, I am getting this error (in Database Mail log) when i send a test mail to Operator.  Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2010-09-07T10:31:24). Exception Message: Cannot send mails to mail server. (A recipient must be specified.). ) Any idea why Database Mail is able to send email when email address is specified and fails to send email to the same address when used in operator? Thank You, V

Mail data is truncated in Database mail

I have sent mail using Database mail...But I am getting only part of data in mail... The mail size remaining same. 8kb Is there is any limitation on mail size???Cheers...vaibhav

2-Way Connection between SharePoint List and SQL Database?

We currently have a SQL database with an Access front-end.  It's clunky and everyone hates it, of course.  Is there a reasonably simple way to tie a SharePoint list to a table in the database so that items can be entered in the SharePoint List and show up in the database, and vice-versa?  The reason for keeping the database is that some data is entered by users in Access, but some comes from an external source - thus, the need for a 2-way connection. It's MOSS 2007.

How to stop the mail trigger while editing a task list item in sharepoint 2007

I have a requirement to stop the mail trigger while editing a task list item in SharePoint 2007. When I am creating a task the mail is sending to the “Assigned to” Properly. But when I am editing the same task item again a mail is sent to the Assigned to user which I want to stop. Is there any out of box feature / settings to stop this mail trigger while editing. Early response is much appreciated.Deeptyranjan

Nice way to ask user to choose a document and then list of recipients for a mail merge?


I'm building what could be described as a mail merger. A user chooses an email template, chooses a list of recipients, and the application performs a mail merge.

I could attach the workflow to contact lists, in which case I only need to ask the user for the email template to use.
I could attach the workflow to document lists, in which case I only need to ask the user for the recipients to sent to.

I decided though that I'd bring them to a starting page and let them choose both. But I've a horrid and barren looking aspx form.
Is there any nice way of letting them browse for the documents and contacts? At present I'm using a couple of dropdown lists listing all documents on the site, and all contact lists on the site, but it's a bit butt-ugly :D

I wrote a book :) http://www.amazon.com/Microsoft-Visual-Studio-2008-Programming/dp/0071604081
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend