Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-11 : 09:19:21
|
| Sean writes "Hello,My name is Sean Barker and I am a developer in Kansas City, Missouri. I have used SQL Mailer (xp_sendmail) is the past and really like it. I am attempting to use it on a production server, which does not have domain access. My question is:Since I need domain access to user SQL Mailer, can I create a VB script file that does the email for me (using ASP mailer) and schedule the script to run? I would like to give the server domain access...and then use SQL Mailer, but we like the tighI have a table set up with all appropriate emails. Therefore, I thought I could create a record set in the VB script and just execute the script via a DTS package? I appreciate you help. Thanks, Sean Barker MCSD" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-12-11 : 16:08:17
|
| If SQL Mail is not an option then there are ways to send mail as long as you have SMTP access (either on the SQL Server or through a remote SMTP server). Have a look at[url]http://sqldev.net/xp/xpsmtp.htm[/url][url]http://www.sqlteam.com/item.asp?ItemID=5003[/url]HTHJasper Smith |
 |
|
|
|
|
|
xp_sendmail (SQL Mailer)