Solved

Does Outlook need installed on database server for xp_sendmail to work

Posted on 2015-01-09
4
83 Views
Last Modified: 2015-01-09
I have been asked if outlook needs installed on database server for outlook to work?   Can someone help..
0
Comment
Question by:spoye
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:Kyle Abrahams
Comment Utility
You need some mapi client for XP_Send_Mail

However you can use msdb.dbo.sp_send_dbmail to accomplish your task.
0
 

Author Comment

by:spoye
Comment Utility
Sql 2000 is currently installed we now have outlook 2013, network admin is asking if outlook need installed on database server.   I am not sure 2000 support  send_dbmail?
0
 
LVL 39

Accepted Solution

by:
Kyle Abrahams earned 500 total points
Comment Utility
That's a 2005 feature (saw that from the zones you posted in).  If it's 2000 only then yeah, put outlook on the box and call it a day or get an upgrade.  You're only 14 years out of date!
0
 

Author Closing Comment

by:spoye
Comment Utility
Thanks...im just a small fish in the pond.  They have been told over and over for years.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now