I am trying to figure if SQL Server has a feature to log when a user fires statements as revoke, delete from, etc.
It would be great to see which user has fired the command, date and time, and which command has been run.
Is there a way to accomplish this in SQL Server 2008?
I have seen this but it is not what I am looking for.
Best Answer
SQL server does not trace revoke or deletes by default. In order to trace those activities, you need to run a server side trace (or XEvents as Aaron pointed out).
Below trace will help you to find command (Text), start date, end date, login, database (I have filtered it for
test_kin
), and many other fields.Adjust the filters as per your need and environment. Also, specify how big the trace file would be through
@maxfilesize
.Below is the screen shot :