How to Get SQL Logs (UPDATE, INSERT and DELETE)
What for DML logs, by default there are non, as long as you haven't implemented a logging, e.g. using DML trigger:
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
How to Get SQL Logs (UPDATE, INSERT and DELETE)of Specific Table from SQL Server if Query run from Website.
Please Help
How to Get SQL Logs (UPDATE, INSERT and DELETE)
What for DML logs, by default there are non, as long as you haven't implemented a logging, e.g. using DML trigger:
Hi @Faizan Ahmed ,
Run SQL server query on website to query data from SQL server table? If so, the operations (UPDATE, INSERT and DELETE) of SQL table are still writed to SQL server transaction log.
You can use ApexSQL Log is a well-known, 3rd party SQL Server transaction log reader. You can chose the table and operations for table as below screenshot.
Please also check if below blog could help you.
Reading the transaction log in SQL Server – from hacks to solutions
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".