Solved

SQL Mail/xp_sendmail

Posted on 1998-06-10
3
260 Views
Last Modified: 2006-11-17
I need to get some details about how to use MS SQL Server to send a text file via e-mail. For instance:

1) how do I specify a mail server?
2) do I need to have SQL mail running?
3) are there any basic limitations?
4) etc.
0
Comment
Question by:flfmdll
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
vvk earned 20 total points
ID: 1091467
In SQL Mail configuration you need to specify Windows Messaging profile where all necessary configuration values exist.
Of course you must start SQL mail before send or recieve mail.
You can specify Autostart in SQL Executive configuration or start manually by executing xp_startmail. What you means under basic limitations? For example if yu use Exchange server account under which SQL server service started must have permissios to access this mailbox

0
 
LVL 4

Expert Comment

by:vvk
ID: 1091468
If you need additonal specifications regarding this question you can drop ones here or send me directly to vvk@card.ru
0
 

Author Comment

by:flfmdll
ID: 1091469
Ok. I'll try this and what you sent in the e-mail. Thanks.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

705 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

15 Experts available now in Live!

Get 1:1 Help Now