Post reply

Deleted objects

  • August 16, 2006 at 9:57 am

    #172190

    Is there a way to determine when a table,stored procedure, udf was deleted from the database. And also determine what user.

  • August 16, 2006 at 10:46 am

    #655304

    Yes. With SQL 2005. check DDL triggers.

  • August 16, 2006 at 11:49 am

    #655314

    Thanks for reply. Can you give me a little guidance as to where to look and what to look for.

     

    Thanks in advance

  • August 16, 2006 at 12:04 pm

    #655320

    I should have clarified what I was wanting from the beginning. We have recently had some tables and stored procedures disappear and I was wondering if you can tell without having written any triggers.

  • August 17, 2006 at 4:10 am

    #655405

    Use a T-Log explorer tool, that is IF you use Full Recovery.

    And maybe now should be the time to restrict permissions?

     

    Hanslindgren

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

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