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 - 2000-12-09 : 11:33:15
|
Jeff writes "I have a table called "Photos" that stores information related to photos in the file system. Each photo name is the same as an identity field in the table. Record ID 1234 relates to the file 1234.jpg. When I delete record 1234 from the table, I would also like to delete the corresponding file. The files are stored in the file system on the SQL Server machine. Can I accomplish this task using a delete trigger on the table?
Windows 2000 Server & SQL Server 7.0 (Service Packs unknown)" |
|
|
|
|
|
Deleting a file on the server via a trigger