I have the following issue -
something is updating particular table columns when such update is not allowed. I was not able to find the
object (searching in T-SQL and ASP code, server jobs), so I decided to create
AFTER UPDATE trigger on the given table and try to log everything that is possible and will help me to find what is updating the table.
I am wondering what
metadata can I access in the trigger - for example: T-SQL statement performing the update?
Also transaction log back up are made on each 15 minutes, so I guess it is possible to detect the change from the backups having particular information like time and transaction id?