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
 General SQL Server Forums
 New to SQL Server Programming
 Getting a table to send an email

Author  Topic 

Michael71
Posting Yak Master

126 Posts

Posted - 2006-12-21 : 14:51:27
I'm trying to implement DTS and FTP. So that when a company sends or FTP infomation to our server, it runs a script and checks to see if the infomation is correct and sends and email saying successful or unsuccessful.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-21 : 16:21:44
This is highly not recommended.

To do it though, you'd need to write a trigger that would send an e-mail via SQL Mail or Database Mail.

Tara Kizer
Go to Top of Page
   

- Advertisement -