Is there way to capture who and when DML/DQL commands are fired on the table or view in a specific period of time in SQL Server 2019. One option is SQL Trace, but SQL Trace is deprecated and Microsoft suggest to use Extended Events.
Looking for a some simpler solution.
Naveen KumarPosted Mar 5, 2024, 12:50 PM
Thanks Jignesh and Prasad for your input.
For time beign using SQL Server Audit, since it is not giving more detailed information. So exploring and working with Extended Event for a permanent solution.
Jignesh KumarPosted Feb 27, 2024, 4:04 AM
Hello Naveen,
You can do this using the below are few options in the SQL server, You can check out below options for each and try to implement
Prasad RaveendranPosted Feb 25, 2024, 4:27 PM
Check whether Server Audit can be leveraged.
https://learn.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine?view=sql-server-ver15