Post reply

All tables in a database that got updated at a certain time.

  • May 31, 2006 at 12:49 am

    #103173

    Dear All,

    I have just started as a DBA at this organisation, and there is no proper handover available. So, I need to start using the application and check what transaction effects which tables.

    So, I was wondering if anyone knew of a script that would tell which data in which tables of a certain database has just been updated/added etc.

    Thanks for your help in advance.

    Regards,

    TK.

  • May 31, 2006 at 2:08 am

    #640844

    There is no such script for this, but you can still achieve it be running the trace on the server enabling insert update event on the required db.

    ------------
    Prakash Sawant

    http://psawant.blogspot.com

  • June 1, 2006 at 3:22 am

    #641117

    Thanks Prakash. I'll try that.

    Cheers,

    TK

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

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