Who Dropped Your Table? - SQL in Sixty Seconds 112

Have you wondered who dropped any table in your database? Or even the entire database? It is easy to figure things out if you have default trace on.

0:00 Intro
0:14 Real World Scenario
0:46 Script for Who Dropped Table
2:20 Summary
3:03 Unedited Clip

#SQLServer #PerformanceTuning #SQLAuthority

[mandarkarnik]

I liked the concept. Quick Videos like this helps rather than reading lengthy wording.

[PuneetSharmaMale]

You done tremendous job on website. Helped us many timea.. now this 60 secs is also really very useful

[ravindranathkanojiya]

Good point Pinal, I will take note of it

[rohansukre]

Nice video, along with Schema changes history there are other reports tab, can you plz make separate video on that?

[ChamilMendis]

It seems Schema Changes History report shows the data only for the current date. Is there any way we can generate the report for a specific date period ?

[kothuripraveen]

Some one dropped my table/index etc but I noticed after a month ago then that info may erased from default traces... in that scenario... how can we identify who has dropped my table/index etc from default traces ?

[anjaliankurdubey]

Great information. But is any way to figure out who delete some of row from table.

[SamSam-hdsf]

Hi, can we find who made changes to stored Procedure using this Schema change history option

[amitbhardwaj]

Thank you sir for good this information 😎

[atozitoj]

Cool thing, learnt most of administration things from your blog.... Thanks for sharing your knowledge.


I had doubt/question about this particular thing..
For a busy instance this may not be possible, as default trace gets overwritten with in hours/minutes any other channels where we can find this change?

Also, can I configure my instance to maintain more than 5(1 active + 4 old files) trace files and If this is possible I'm assuming this will not impact SSMS reports performance and Database performance!!!

[zberteoc]

This must have some configuration settings because in my case the report shows nothing.

[bpfrenchak]

Great video! How long of a history does this report keep?

[udayelluru]

Great video, Do we have any log history of who performed DML operations on a table from SSMS?

[harishkumarreddy]

Hi sir
One more thing I have to know how can we check who was truncate and delete particular table

[savananjaria]

Can Dataedo be used as exact alternative to this or Schema Change History has got some unique features that overrides Dataedo?

[MANISHKUMAR-sptc]

is that still would be visible if the particular table deleted from the application by its some functionalities.