Post reply

Determine WHEN a Stored Proc was dropped....

  • October 25, 2004 at 10:37 am

    #162531

    Hi all need a little help determining when a SP got dropped.  We have a user that states they did nothing to the DB but after checking our INLINE code, and the developer who wrote the SP, we have decided that the users Tech people somehow for some reason dropped the sp in question.

     

    I guess my real question is how would i use the Transaction log to determine this?

     

    I know I can use sysobjects to determine when an sp was created, but how to know when an sp was dropped?

     

    Any and all help greatly appreciated

  • October 25, 2004 at 11:51 am

    #527864

    You'd need a third party tool like Log Explorer (Lumigent) or ApexLog (Apex SQL)

  • October 26, 2004 at 4:01 am

    #527933

    And that depends that the log is still intact with the point in time it occurred. If you have set to Truncate in SQL 7 or Simple Recovery in 2000, or you have cleared the TLog since it occurred you will have no way unless you can restore a copy of the log that contained the transaction to another location.

  • October 26, 2004 at 5:59 am

    #527951

    Pretty useless after the fact has occured unless you want to slap someone on his hand.

    What about reviewing your permission concept? Why does anyone have such privileges on a production system?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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