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 |
|
hnomani
Starting Member
35 Posts |
 Posted - 2006-03-29 : 16:28:44
|
| I am trying to figure out what processes insert/delete data to one of the table in our database. There are several nightly jobs that runs DTS packages in our database.I have created FOR Insert and FOR Delete trigger on this table to record system_user, getdate() whenever an insert or delete happens. But when I tested this process by inserting data through DTS I found out that FOR Insert trigger never fired. Should I try any other trigger that will fire on DTS inserts or any other technique to figure out about the jobs that inserts data into the table?Thanks |
|
|
|
|
|
FOR Trigger does not fire on DTS Inserts?