NickyPower
asked on
How to trace transactions against a table
A number of records in a table have been periodically removed. How can I execute a trace on the table to check what is happening to these records?
You can write a trigger on that table to perform audit on that particular table and capture User name along to track what happened to the records.
ASKER
I am not a SQL Server expert so i am not too sure how to start writing a trigger...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.