SQL Mail/xp_sendmail

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.
flfmdllAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
vvkConnect With a Mentor Commented:
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
 
vvkCommented:
If you need additonal specifications regarding this question you can drop ones here or send me directly to vvk@card.ru
0
 
flfmdllAuthor Commented:
Ok. I'll try this and what you sent in the e-mail. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.