Home Forums SQL Server 2008 SQL Server 2008 - General How can I find who/what process dropped view/table from my sql server 2008 database ? RE: How can I find who/what process dropped view/table from my sql server 2008 database ?

  • There is a built in report in SSMS that uses the default trace to show schema change history.

    Right click on the database where the table was dropped from, then Reports -> Standard Reports -> Schema Changes History