How to see who made a change to a table in SQL Server Is it possible to see who changed a table (or a stored procedure) in a database when the recovery model is simple? E.g. length of data type...
If the recovery model is full will it be possible so see this in the log file?
Is it only with a trigger that one can log every access to a table or is there a build in option for this?
You should have an extended event session in place but as a quick and dirty solution you can use the report below: