Post reply

How to find who deleted a view

  • May 7, 2014 at 7:30 pm

    #288544

    Hi, I need help to find out who deleted a view from SQL Server.

    I went to Database/reports/ standard reports/schema changes history but the deleted view does not show in this list.

    Thanks,

  • May 8, 2014 at 12:44 am

    #1711760

    In that case, unless you have some custom auditing in place, you don't find out. The default trace (which populates that report) tracks DDL changes, but SQL only keeps 5 files of 20MB, so older records get deleted.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 8, 2014 at 10:15 am

    #1711950

    Okay, thanks.

  • May 8, 2014 at 11:52 am

    #1711986

    You could set up a server side trace to capture events for the future. I have 1 running 24/7 and have found it useful from time to time. I set up a purge job to delete the trace files after X weeks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply