Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > SQL Mail


Search:
What's New - What's Hot
An Introduction to SQL Mail and SQLAgentMail     
Total Hits: 2086  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, you will learn how to set up and use the e-mail services in Microsoft SQL Server 2000. Most of what you'll learn applies equally well to Microsoft SQL Server 7.0. You'll discover that it's actually rather simple to integrate your back-end database with your e-mail system....

Sending SMTP Mail using a Stored Procedure     
Total Hits: 1866  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

One of the downsides of SQL Mail is the fact that it is tied to a MAPI Profile. Here is a way to send email using the sp_OACreate procedure to call a third party SMTP component....

User Tips: Receiving an Email When Database Data is Changed     
Total Hits: 238  |  Today: 0Author: Wade Wilbur      Rating:  
Read Reviews | Write Review |  Your Rating: 

For low-volume databases, those that are predominantly read and not written to, or database tables that are designed to not be updated or only updated under rare circumstances, a DBA or developer may be interested in being notified whenever the data in a particular table is modified. Or you may have certain records in a table that are assigned to a particular user and, upon that record being updated, that user should be notified of the change. While this sort of logic can be implemented at the c...

Send SMTP Email from SQL Server     
Total Hits: 578  |  Today: 0Author: Peter A. Bromberg, Ph.D      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server has a built - in system stored procedure, xp_sendmail, that allows you to send out email. Unfortunately, it requires the use of the MAPI provider through either Exchange or Outlook (a.k.a. "Windows Messaging"). Although some third party mail tools, such as Lotus Notes, offer MAPI providers, I have found that even the Microsoft MAPI interface can be both bulky and buggy at times....

Troubleshooting SQL Mail with Exchange Server     
Total Hits: 353  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Typically, errors that occur when starting a SQL Mail session or sending mail from SQL Mail with Microsoft® Exchange Server fall into these categories: permissions problems and Exchange client setup problems....

INF: Troubleshooting SQLMail with Microsoft Exchange Server     
Total Hits: 917  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

You can use certain basic troubleshooting techniques to diagnose and
resolve most SQLMail problems. Typically, errors in starting a SQLMail
session or sending mail from SQLMail with a Microsoft Exchange Server fall into two categories: permissions problems and Exchange client setup problems. SQLMail functionality is documented in the "Books Online" for version 6.x. These should be thoroughly reviewed before using SQLMail....

HOW TO: Send E-Mail Without Using SQL Mail in SQL Server     
Total Hits: 2459  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Mail provides an easy way to send and read e-mail from SQL Server. However, because SQL Mail is a Messaging Application Programming Interface (MAPI) application, a MAPI subsystem must be present on the server. Microsoft Windows 2000 does not provide a MAPI
subsystem (Microsoft Windows NT 4.0 installs a MAPI subsystem when you install Windows Messaging). Therefore, in order to use SQL Mail, you must install a MAPI client such as Microsoft Outlook....

SQLMail in Depth     
Total Hits: 1104  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQLMail provides an interface from SQL Server to any MAPI-enabled mail client. This interface is a collection of extended stored procedures that allow you to send and read e-mail using Transasct-SQL statements....

Troubleshooting SQL Mail     
Total Hits: 375  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you have problems with SQL Mail, review this 20-point troubleshooting checklist to find potential solutions....

Using SQL Mail Stored Procedures     
Total Hits: 1120  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Mail contains a number of stored procedures, which allow you to develop triggers, applications, and other stored procedures. The stored procedures can then be used to manipulate mail, run queries, return a result set to a list of recipients, or reply to an e-mail containing a simple query or stored procedure....

How to use SQL Mail (Transact-SQL)     
Total Hits: 1035  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Mail uses several extended stored procedures that are necessary for mail enabling. These extended stored procedures are included in a dynamic-link library, SQLMAP70.DLL, which is installed with Microsoft® SQL Server™ 2000....

Use of SQL Mail     
Total Hits: 615  |  Today: 0Author: Stephen Dybing      Rating:  
Read Reviews | Write Review |  Your Rating: 

This document describes how to set up Microsoft SQL Server 7.0 to use SQL Mail with a Microsoft Outlook client and Microsoft Exchange Server. It assumes that you have already performed a Typical installation of SQL Server, installed a Microsoft Outlook client on the SQL Server, and have a Microsoft Exchange Server computer installed somewhere on your network....

Configuring and Managing SQL Mail     
Total Hits: 1079  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Mail consists of a small set of items that must be configured to know the accounts and servers that will be used to send and receive mail. It simply consists of a mail service setup on the SQL Server along with SQL Mail configured to use that service.

...

COM Objects in SQL: Sending E-mail using SQL and CDONTS     
Total Hits: 917  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft's SQL Server provides e-mail services via the SQLMail service. Unfortunately, this service has some significants limitations. It uses MAPI, requiring an Outlook mail profile (usually tied with a Microsoft Exchange Server mailbox). As a result, all messages created will come from the same mailbox (everything is "from" the same person)....

An alternative to SQL Server email alerts     
Total Hits: 213  |  Today: 0Author: Edwin Sarmiento      Rating:  
Read Reviews | Write Review |  Your Rating: 

In a tip on How to setup SQL Server alerts and email operator notifications, you have seen how you can configure email alert notifications in your SQL Server instance. There are cases where we cannot use SQL Server alerts like in a SQL Server 2005 Express instance or a clustered SQL Server 2000 instance as the MAPI interface used by SQL Mail is not cluster-aware. What other alternatives do we have for sending email alert notifications? Sending email alert notifications is one way of letting Data...



Disclaimer - Privacy
© 2002-2017 DevASP.net