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 |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-01-12 : 13:32:38
|
| Well,I have been trying to find some decent information on a particular set of tasks surrounding triggers.I need to track what users are doing in terms of update/insert/delete in a table that has their user id, the date, the record that was updated, the table it was from, and if it was an Update/Insert/DeletePretty simple. Problems: Can I get the accountname of the user who requested the update/insert/delete ? {I am using ASP on the front end to make ado calls}I am sure I can set up the triggers for the tables, but how do I grab the @@identity of the record that was affected? Whether its Insert/Update/Delete? And How do I find out what operation was performed? (i can always write 3 separate triggers for that.)I would greatly appreciate some info. I am in a pickle on this one.I have done alot of searching with 0 results.ThanksVivaldiSoftware Composer |
|
|
|
|
|
Triggers and user tracking