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)
 Sending e mail in SQL Server 7.0

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-06 : 07:38:02
Michael writes "I am doing a third year project involving SQL Sever. Its an e commerce ebsite. I need to be able to send an e mail to a customer as soon as they place an order on my website and also send an e mail to my suppliers ordering the products which the customer has just ordered. I have been told that a trigger is the best way to do this but I have no idea how to write a trigger like this. Can someone please help me ? By the way I am using SQL Server V7.0"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-02-06 : 07:55:01
Hi

Try doing a search.

http://www.sqlteam.com/SearchResults.asp?SearchTerms=mail

Look at the queue idea, you could use a trigger with that

http://www.sqlteam.com/SearchResults.asp?SearchTerms=trigger



Damian
Go to Top of Page

jackstow
Posting Yak Master

160 Posts

Posted - 2002-02-06 : 08:14:45
This should do the trick;

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=10447

Jack

Go to Top of Page
   

- Advertisement -