who is running a select statement on SQL server tables

DataNerd 21 Reputation points
2023-04-25T14:56:40.29+00:00

Who is running a select statement on a sql server table

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,125 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 104.2K Reputation points MVP
    2023-04-25T20:34:57.31+00:00

    Maybe your best option is to upgrade. Starting with SQL 2016 SP1, Database Audit is supported in Standard Edition.

    If you need to stay on SQL 2014, Extended Events or Trace are your only options.

    In any case, if you insist on staying on SQL 2014, you should at least Service Pack3 and slap on Cumulative Update 4 for SP3, to get all updates for SQL 2014.

    0 comments No comments