• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

XP Mail

Experts,

Does anyone know where I can find a brief tutorial on xpmail for SQL Server?
0
NigelRocks
Asked:
NigelRocks
  • 2
2 Solutions
 
Anthony PerkinsCommented:
Are you talking about SQL Mail?  That uses MAPI was the only option offered natively by SQL Server 2000 and for the most part has been deprecated in SQL Server 2005/2008.
0
 
NigelRocksAuthor Commented:
I thought it was called xpmail.  Is there a way to send email from within a SQL Server 2000 script?
 
 
0
 
Anthony PerkinsCommented:
Yes, you can use SQL Mail to send emails, howerver, the devil is in the details.  For one you have to have Outlook installed on the server.  For most DBA's that is a non-starter.  A better approach IMHO is if you use SMTP mail (as opposed to MAPI) and use a third party tool such as this one:
XPSMTP.DLL - SQL Server SMTP Mail XP
http://www.sqldev.net/xp/xpsmtp.htm

This is very similar to what is currently used in SQL Server 2005 (DB Mail), so it should make your future transition painless.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now