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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

HELP with SQL MAIL, a deprecated feature of SQL

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
 
I understand that SQL MAIL is a deprecated feature of SQL, thru SQL 2008r2.  However, I am despirate to continue using the READ and DELETE funcationality as long as I can.  Anyway... I am running SQL 2005 (build # 9.0.4262).  I am connecting to a company Exchange account via the SQL MAIL / MAPI system procedures. I am very sure my code is good, as it runs on three different SQL installations, every 10 minutes.  I eliminate 'auto reply', 'user replies', etc. from my three different account inboxes, and therefore keep those inboxes very clean. I am unable to get the process "xp_findnextmsg" to return a message-ID for any messages with "Undeliverable:" in the subject line.  I did send one 'TEST' email (from my account) into the account inbox and "xp_findnextmsg" does return a message-ID for that one.  My research indicates that the "Undeliverable:" replies from Exchange servers may have special headers. Has anyone else encountered this issue, and/or a solution? I have accumulated over 600 "Undeliverable" messages in my inbox, as my MS Report Server 2005 uses this account for Subscriptions.  I would love to read the Subject and first 'x' characters of Body into a SQL table, so I can build SSRS reports back out to report/subscription owners.


View Complete Post


More Related Resource Links

HELP with SQL MAIL, a deprecated feature of SQL

  
I understand that SQL MAIL is a deprecated feature of SQL, thru SQL 2008r2.  However, I am despirate to continue using the READ and DELETE funcationality as long as I can.  Anyway... I am running SQL 2005 (build # 9.0.4262).  I am connecting to a company Exchange account via the SQL MAIL / MAPI system procedures. I am very sure my code is good, as it runs on three different SQL installations, every 10 minutes.  I eliminate 'auto reply', 'user replies', etc. from my three different account inboxes, and therefore keep those inboxes very clean. I am unable to get the process "xp_findnextmsg" to return a message-ID for any messages with "Undeliverable:" in the subject line.  I did send one 'TEST' email (from my account) into the account inbox and "xp_findnextmsg" does return a message-ID for that one.  My research indicates that the "Undeliverable:" replies from Exchange servers may have special headers. Has anyone else encountered this issue, and/or a solution? I have accumulated over 600 "Undeliverable" messages in my inbox, as my MS Report Server 2005 uses this account for Subscriptions.  I would love to read the Subject and first 'x' characters of Body into a SQL table, so I can build SSRS reports back out to report/subscription owners.

Using SharePoint Search feature in ASP.Net Application

  
Integrating ASP.Net application in to MOSS 2007 to utilize SharePoint Enterprise Search Feature can be done by using Business Data Search.

Mail Merge

  

Hi,

 

I am after creating a mail merge documents from datasource and .dot template file on server side. Can you give me an idea how i will achive this?

 

Thanks in advance.

 

Regards,

Syed Hussain

 

 


May i use the collapse and expand feature (like tree menu) in Report ?

  

HI all,

May i use the collapse and expand feature (like tree menu) at Report iam using the Report viewer  Control for displaying the Report on my Asp.net Page .

 

I have number records and each record have detail as i clicked or expand the record then details will be shown is it possible with report viewer control 
 
If any one have experince before please share the ideas.

 

Best Regards


Email Help (System.Net.Mail)

  

Hi I have a annoying problem. 
I have created a page which takes users details for a quote.

I have then created the form to be emailed to both the user and myself. (Which works fine ATM)

However I would also like to be able to attach a file containing terms and conditions to the email.

I have tried doing this using 

EmailMsg.Attachments.Add(new Attachment("C:\\attachme.txt"));

But everytime that line of code is hit it fails and is caught by my try catch.

Take that line out and the email sends fine, put it in and it breaks the whole page.

Am I missing something really obvious?


C++ Plus: Beef Up Windows Apps with the Visual C++ 2008 Feature Pack

  

Kenny Kerr sings the praises of the new Visual C++ 2008 Feature Pack, which brings modern conveniences to Visual C++.

Kenny Kerr

MSDN Magazine May 2008


Toolbox: Create Graphs, Send E-Mail, Spell-Check, and More

  

Turn boring data into stunning graphs, create, parse, send, and receive mail messages from code, and more.

Scott Mitchell

MSDN Magazine August 2007


BizTalk Adapters: Integrate E-Mail Processing Into Your Business Solutions

  

Use BizTalk Server to monitor e-mail for new messages, trigger confirmations, and persist e-mail and attachments to a custom database.

Alex Starykh

MSDN Magazine December 2006


C++ at Work: Addin a Combobox Cancel Feature

  

This month Paul DiLascia codes some Microsoft Office-style dialog box features.

Paul DiLascia

MSDN Magazine August 2006


Toolbox: Automated Build Process, Real-World E-Mail Tasks, and More

  

While the Visual Studio® Build menu's Build Solution option is the usual way developers compile their current work on a project, the process of building the complete solution for testing, deployment, or production often requires many more steps.

Scott Mitchell

MSDN Magazine March 2006


Editor's Note: Reader E-mail

  

Here at MSDN Magazine, we get a lot of mail from readers. As you can imagine, much of it involves fulsome praise for our content, our eye-catching covers, or the handsome photo that now graces this page.

Joshua Trupin

MSDN Magazine June 2005


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


C++ Attributes: Make COM Programming a Breeze with New Feature in Visual Studio .NET

  

C++ attributes in Visual Studio .NET are used to generate C++ code through attribute providers. Attribute providers generate code for COM classes, and the code is injected by the C++ compiler at compile time. This has the effect of reducing the amount of code that you need to write. In addition, with C++ attributes you no longer need to maintain separate IDL and RGS files, which makes project management simpler. This article explains C++ attributes, the process used by the attribute provider to generate code, and the code that is automatically generated. It also covers how attributes affect the registration process, how attributes can be used to generate code module entry points, and how connection points can be implemented using C++ attributes. Also explained is how these features contribute to the Unified Event Model for the .NET platform.

Richard Grimes

MSDN Magazine April 2001


I cannot send mail using gmail smtp server

  

 Here is my code

Dim message As System.Net.Mail.MailMessage = New System.Net.Mail.MailMessage()
        message.To.Add("from textbox field")
        message.Subject = "Testing"
        message.From = New System.Net.Mail.MailAddress("sender email ")
        message.Body = "Just Testing"

        Dim smtp As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient()

        Dim client As SmtpClient = New SmtpClient()
        smtp.Credentials = New System.Net.NetworkCredential("username", "password")
        smtp.Port = 25
        smtp.Host = "smtp.gmail.com"
        smtp.EnableSsl = True
        smtp.DeliveryMethod = SmtpDeliveryMethod.Network
        lblmsg.Text = "Your Email has send"

        Try
        &

How to send mail to individual users.

  

Hi,

  I need to send the same mail to multiple users separately. I dont want to use comma delimeted "To Address" . Because other users can able to see the recipients.

   Each recipient should not know about the other recipients. 

   How will I achieve this one without for loop ?

Thanks.



Categories: 
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