Share via

SQL Server Audit

Miguel Angel Arriaga Grullon 1 Reputation point
2021-07-07T14:11:31.543+00:00

Hi,

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

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,426 Reputation points Microsoft External Staff
    2021-07-08T06:36:43.67+00:00

    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

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.