Azure SQL Database
An Azure relational database service.
5,442 questions
If you haven't implemented a data audit logging, then you can not get the information afterwards.
How to detect who deleted data from MS SQL database table
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 48%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
Nur Hossain
282
Reputation points
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
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,461 Reputation points2022-01-21T03:18:25.1+00:00 Hi @Nur Hossain ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Sign in to comment
3 answers
Sort by: Most helpful
-
-
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee2022-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-
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
2022-01-24T20:08:18.513+00:00 Please do not forget to mark as accepted answer if the reply was helpful.
Regards,
Oury
Sign in to comment -
-
Seeya Xi-MSFT 16,461 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 ObjectsBest 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.