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 |
|
vmethod
Starting Member
3 Posts |
 Posted - 2007-08-27 : 18:16:57
|
| The low down:Local Web Server on Windows 2003Local SQL Server on Windows 2003Hosting dynamic website tied to inhouse Access ApplicationOk, basically, how it is set up, people can login to our website and enter data (insert record), on our end, we have an Access application where we can play with the data that was entered via the website. Currently, we do not have either server set up as a Mail server.What we need to be able to do:When a customer enters data on our website, their supervisor, and about 2-3 other people related to the transaction need to be emailed to be notified that an order was submitted. So how do I code that? On the page with the Insert Record? OR after Insert Record redirect them to another page that sends the mail out? Which server do I enable the mail?I was reading about SQL Mail etc, which would be good since we do mass emails to clients weekly, but I have no idea how to set that up and I look crossed eyed at any tutorial. Do I want to set up theSQL server to also be a Mail Server that way we can use the SQL database to email as well as data entered from the website? But then again, the website points to the Web Server which pulls data off the SQL server (so unless the Web Server is a mail server, nothing will be sent, am I right?)*sigh* I know very little about SQL and I'm being asked to impliment this and I am 100% confused. I'm a graphics artist not a programmer! LOLThanks in advance to anyone who can/will help me. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-27 : 19:28:52
|
| I wouldn't do this inside SQL Server. The application that is submitting the order should handle the email. Can't Access send emails via SMTP?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-28 : 05:30:40
|
| if you have sql server 2005 you can send mails from it with Database Mail.It's simple and pretty straight forward.and since it's async it doesn't cause issues with transactions running too long_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
vmethod
Starting Member
3 Posts |
Posted - 2007-08-28 : 16:41:38
|
| this is going to sound really incredibly retarded, but how do i find out what version of SQL I'm using... I've looked everywhere I thought it would be. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-28 : 16:45:37
|
| select @@version_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
vmethod
Starting Member
3 Posts |
Posted - 2007-08-28 : 17:58:59
|
| Ok, yea I'm running Server 2000 with SP2 (thanks tk for that) |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-28 : 18:02:36
|
| yeah.. database mail doesn't exist in SS2k.handle it outside sql server._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
|
|
It's complicated