Post reply

information about deleted objects????

  • October 12, 2006 at 1:46 am

    #62213

    Hello

    Is there any way to find information regarding deleted objects (stored procedure or views or functions) in sql server

     

    Regards,

    Papillon

  • October 12, 2006 at 5:05 am

    #665426

    I tend to restore a backup I know contains the objects I need information about then run something like Red-Gate SQL Compare between the two databases to see the differences.

    What information are you after in particular?

  • October 12, 2006 at 8:10 am

    #665504

    Either a backup or possibly a log reader like Golden Gate's LogPI or Lumigent's Log Explorer could script what you need.

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

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