How To Find Deleted Objects in SQL Server

This article contains script to find deleted objects in sql server. It happened to every database administrator. Application developers or your supervisors may ask you to find out who deleted objects in database. Did you know that you can find deleted objects with TSQL even if there is no audit in the database? Yes, this is possible. You can find deleted objects in SQL Server with the help of the following script.

How to Find Deleted Table in SQL Server

Below scripts will help you to find deleted table in sql server, also you can find who dropped stored procedure in sql server. Of course its not limited only table or stored procedure. It applies to all database objects.

Also, you can use SQL Auditing to monitor everythins in SQL Server. Below articles will help you to create and monitor SQL Server audit.

How To Create SQL Server Audit,

How To Read SQL Server Audit

Faruk Erdem
Author: Faruk Erdem

Leave a Reply

Your email address will not be published. Required fields are marked *