I need to monitor queries executed by a specific set of users on a database. I need to check them on a weekly base. Is that possible on SQL server 2008r2? And 2016?

  • A little more context might change what the best answer is for you since there are multiple ways to accomplish this (at a high level). What kind of queries do you need to log?... DML queries such as INSERT, UPDATE and DELETE; DDL queries such as CREATE, ALTER, DROP; DQL queries such as SELECT; or all of the above? – J.D. Feb 27 at 22:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.