Who Deleted the Table ??

  • A table got deleted from the database. I have a full backup & transaction logs, so I've restored it. Is there any way to use the logs to find out who deleted it ?? I don't have any 3rd party tools right now.

  • What about perusing the defualt trace files?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • DavidB (9/30/2008)


    What about perusing the defualt trace files?

    I should have posted this in the 2000 section, not 2005. D'oh !! :pinch:

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

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