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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,149 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,665 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,321 Reputation points Microsoft Vendor
    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 No comments

Your answer

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