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 ?

  • January 23, 2013 at 1:32 am

    #1579937

    Default Trace - A Beginner's Guide - http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

    If the event is no longer in the trace then and you dont have auditing like DDL triggers, extended events setup then your out of luck finding who dropped it.