Who deleted any object from DB

• rite2shubhra

  SSC Journeyman

  Points: 94

  More actions

  August 5, 2009 at 1:55 pm

  #156066

  Hi Everyone,

  I created couple of views in the DB and looks like some of them are missing? I have the script so I can recreate them, but I wanted to if I can find out how come it got obselete. Is there any place in SQL Server where it stores that data, when the object got deleted and who did that?:unsure:

  Please help me!

  Thanks in advance,

  Shubhra

• GSquared

  SSC Guru

  Points: 260824

  More actions

  August 5, 2009 at 1:58 pm

  #1035071

  If the database is in Compatibility 90, you can check the Schema Changes report. You might also find what you're looking for in the default trace.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon