SQL Server Audit

Miguel Angel Arriaga Grullon 1 Reputation point


I want to know who executed what in a SQL Server, I'd like to know everything that user executed in every SQL sentence.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,736 questions
{count} votes

1 answer

Sort by: Newest
  1. CathyJi-MSFT 20,976 Reputation points Microsoft Vendor

    Hi @Miguel Angel Arriaga Grullon ,

    SQL server audit could not meet your requirement.

    You can using the SQL profiler trace to achieve this, but it is impossible to run the profiler trace for a long time.

    Please check if below blog could help you.

    How to Check SQL Server Query History

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

    0 comments No comments