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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-15 : 00:05:30
|
Paresh Joshi writes "We store support-files submitted by the users over the web in the SQL database in the image field. As soon as the files are stored in the database we want them to be sent to concerned person using xp_sendmail as an attachment.
xp_sendmail takes attachment from the hard-drive, so within the trigger initiated by the insert operation, we would like to extract the file to the hard-drive and after the extraction send it to the user using xp_sendmail.
We cannot take it directly from our web server, since web server is on the DMZ.
Thanks,
Paresh." |
|
|
|
|
|
extracting files stored in the image field to a directory on the server within a trigger.