How do I get access logs from SQL Server database I am in the process of carrying out system reviews for some systems powered by SQL Server. IS there a way of getting the access logs to these systems databases spanning a period of 6 months starting from January 2020 to June 2020?
Is there a specific query that I can run to extract for me access logs on a given system FROM a given date TO a certain date?
At least, you can create table with fields for username, date and time and information about transaction. Secondly, you should create trigger functions for your tables, function should write logs into you log table, this allow you to access your logs quite simply.