SQL Server: How to trace & capture who change data and what sql is used to change data etc

Question

Our company has a consultant DBA. who often tell me who changed data like (user pc name, ssms or .net application which one used to changed data etc) and what sql has been used to change data.

for professional secret consultant DBA will not disclose his tricks before me that how he acquire those info from sql server database.

he gave me all these information without any trigger. so how DBA trace all these info? do they use any 3rd party tools if yes then which 3rd party tool gives this kind of info?

please tell me some way out to trace those info from db without trigger. when our DBA gave me this info from db it means those data stored in db. so i need to know from where i can get those info and what sql i need to issue to get those info.

please guide me. thanks

Answer 1

Hi,

You can consider to create trace with sql server profiler ,or use SQL Server Audit.

A similar case for your reference.
https://learn.microsoft.com/en-us/answers/questions/162506/sql-server-how-to-find-out-who-update-table-data.html