Share via

Who is running a select statement on a sql server table

DataNerd 21 Reputation points
2023-04-18T15:20:55.6466667+00:00

Hello, I am trying to find out a way to know who is running a select statement on a few of my tables on a SQL Server, I know SQL Audit can do this easily but the version that I am trying to configure this is on SQL Server 2014 SP1-GDR Standard Edition and SQL audit is not helping me here since I am getting an error saying it is not supported. The result I want is like User A ran a select statement on a this day on this table and I would like to save this to another table, thank you.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,756 Reputation points
    2023-04-19T06:56:59.9733333+00:00

    Hi @DataNerd,

    All editions support database level audits beginning with SQL Server 2016 (13.x) SP1.

    Please refer to this MS document: Features Supported by the Editions of SQL Server 2016

    You can upgrade your SQL Server.

    One approach is to use SQL Server's built-in system views and functions, such as sys.dm_exec_connections, sys.dm_exec_sessions, and sys.dm_exec_requests, to capture the information you need.

    There is also a tool named Extended Events that you can use.

    https://www.sqlshack.com/using-sql-server-extended-events-to-monitor-query-performance/

    Best regards,

    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.