How to detect who deleted data from MS SQL database table

Nur Hossain 282 Reputation points
2022-01-18T07:26:29.68+00:00

I have SQL server 2016 database server. I noticed that, someone deleted data from Specific table.

Is there any way to find out who deleted data from MS SQL table.

Multiple user has access on that table.

Thank You

Azure SQL Database
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,074 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,579 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 42,386 Reputation points
    2022-01-18T07:47:37.137+00:00

    If you haven't implemented a data audit logging, then you can not get the information afterwards.

    0 comments No comments

  2. Oury Ba-MSFT 17,061 Reputation points Microsoft Employee
    2022-01-18T18:50:18.617+00:00

    Hi @Nur Hossain Thank you for posting your question on Microsoft Q&A.

    In addition to @Olaf Helper 's answer If you don't have audit logs enabled you won't be able to perform the above operation.

    You can find out out by reviewing the activity log if the delete operation was done via the Azure Portal.

    Regards,
    Oury


  3. Seeya Xi-MSFT 16,451 Reputation points
    2022-01-19T03:35:04.9+00:00

    Hi @Nur Hossain ,

    Welcome to Microsoft Q&A!
    I suggest you read this article, which contains detailed how-tos and explanations. I believe this will be useful to you.
    How to find user who ran DROP or DELETE statements on your SQL Server Objects

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments