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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 email notifications

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-25 : 08:19:07
Tony writes "Hi All

I 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

Go to Top of Page

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 currently

HTH
Jasper Smith

Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2002-06-25 : 12:51:31
see below also......it has spawned multiple conversations on this site....

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=13992

Go to Top of Page
   

- Advertisement -