Hi,
Iam looking to trace the DB entry and transaction log, can anyone suggest me how to trace who has created the record.
for example there are projects created, I want to know who has created the projects header and details.
Thank you,
You may simply active CreatedBy property on a table and let AX to track it for you. Then you can easily access this information inside AX.
If you have a good reason for logging at the database level, look at SQL Server Audit, which is much more robust (and complex) solution.