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 |
|
nareshbhatt2009
Starting Member
3 Posts |
 Posted - 2011-05-10 : 08:22:11
|
| I have one query regarding this can you help me guys…I explain my problem with an example :Suppose i have a table named as ‘Employee’ and have a columns name : emp_id,emp_name,emp_designation,emp_salary.and i want a trigger who audit my table employee for any updation and the audit table have following columns : audit_id(thats should be assigned to any updation),updated column name(the name of the column that changed),previous value(previous value that a row hold), updated vlaue(changed value),updated time.Pls reply as soon as possible ...thanksnaresh |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
|
|
|
|
|
Problem with audit trigger