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-06-25 : 08:19:07
|
| Tony writes "Hi AllI have just finished designing and will be implementing a hotel booking application (database) using ultradev4 as the front-end solution shortly. However, I want to take this one step further.I want to be able to send email notification to the hotel(s) once a booking is made by the client and the data gets stored into my database. Does anyone know how to go about setting up this task using SQL Server 2000?Also, if there is a more efficient way of setting this up I am 'all ears'.Thanks" |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-06-25 : 08:20:38
|
| Look up xp_sendmail in Books on Line |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-25 : 10:42:39
|
| If you just want to use SMTP then you can have a look at [url]http://www.sqldev.net/xp/xpsmtp.htm[/url]THis allows HTML mail - something xp_sendmail does not currentlyHTHJasper Smith |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
|
|
|
|
|