How to detect who deleted data from MS SQL database table

Nur Hossain 76 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.
9,086 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 27,136 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.

  2. Oury Ba-MSFT 10,326 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 15,036 Reputation points Microsoft Vendor
    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.