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 ?
Nils Gustav Stråbø
SSChampion
Points: 11259
More actions
January 23, 2013 at 7:15 am
#1580072
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