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 |
|
Ishamael
Starting Member
14 Posts |
 Posted - 2006-09-24 : 21:34:00
|
| Hey guys,I have a Access adp that backs onto SQL Server 2005, its taken a while but tis nearly done.Just one last thing to figure out.. and thats how to send a email. I had a look at all the Access ways and they just wont work out for this.So I decided to use the server to send them, I would insert/update a row into a table which has a trigger on it.The table has amoung other things a Approved and Declined column.Both at 0 Sends an email to an ApproverApp 1 Dec 0 Sends on furtherand App 0 Dec 1 sends back to the original sender.All I really want to know is could a trigger execute a package or something that will send the email? (Yes thats right someone isnt asking for code for once:D meh must be winter in hell)If theres any flaws in my idea please feel free to tell me (Saves me denting the desk with my head half a week and 10 pages of code from now)And where do I create triggers:P (Will probly have found this one in BOL by the time anyone replys)Sorry about this but I really have no clue about triggers.. seems the site doesnt like me searching for triggers'This page was generated in 17.03 seconds.':P |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-24 : 22:02:29
|
| Have a look at xp_sendmail. This is the main proc used to send main in SQL Server. You shouldn't need to create a package just to do this.I would tend to do this in the front-end though (using the CDO libraries). |
 |
|
|
Ishamael
Starting Member
14 Posts |
Posted - 2006-09-24 : 22:10:39
|
| Most the front end ways had a awful habit of walking head on into Outlook, which throws up a message when Access trys to email. Something along the lines of "This could be a Virus". Might panic the poor clients a little:PThanks for the proc, will look into it :) |
|
|
|
|
|
|
Can i get a comment or two on this