Post reply

Metadata - Database Drops

  • March 3, 2008 at 1:55 pm

    #128185

    Is there any system table or view that records the drop of a database?

  • March 3, 2008 at 2:01 pm

    #784671

    Not that I am aware of, sorry. You can setup a DDL trigger to capture that event at a server level, or setup a trace to capture that as well.

    😎

  • March 3, 2008 at 2:26 pm

    #784677

    You can also prevent objects from being dropped with DDL triggers. This works espeically well in production environments. You can log all the information about who tried to do what and then send the user a message stating that dropping/altering is against policy.


    My blog: http://jahaines.blogspot.com

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

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