question

TZacks-2728 avatar image
0 Votes"
TZacks-2728 asked Criszhan-msft answered

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

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

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Criszhan-msft avatar image
1 Vote"
Criszhan-msft answered

Hi,

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

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.