Solved

SQL Mail/xp_sendmail

Posted on 1998-06-10
3
287 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

635 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