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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-08-24 : 04:32:57
|
| Dear All,As part of the Audit i need to create a trigger which captures following information And there is already one trigger exist on the table which is used to maintain history records, can i create one more trigger on the same table with the following information to capture The Audit trail shall record:User nameDate and time (h/min/sec),Indication of record (or file) creation, modification or deletion,In case of modification or deletion: old value,Reason of change (if applicable). Any help in this regard highly appreciated Thanks,Gangadhar |
|
|
|
|
|
Triggers to capture audit trials