All we need is an easy explanation of the problem, so here it is.
I created a user and I would like to know the history of the stored_procedures he manually ran and the SQL queries he executed, how do you do that? Is this possible in MSSQL?
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
What you’re looking for is a feature called SQL Server Audit which allows you to specify a number of events that get logged, including who runs which stores procedures and queries. I believe specifically you’ll want to enable the database audit in the specific databases you want to log, when you care about those kinds of events.
The catch is you have to enable and configure it first, as it’s not on by default. Also please note auditing features of SQL Server do add some overhead to resource consumption, especially with the more events you setup to be audited.
Please also see A quick overview of database audit in SQL for further information and overview on how it works.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂