Post reply

Trace data from an App

  • September 16, 2004 at 4:55 am

    #85380

    Hi to all

    Is any way utility to be able to trace and report witch tables are updated when data is entered in one table. I would like to see all the tables that get the effected from onw insert or update.

    Thank you

     

  • September 16, 2004 at 6:08 am

    #523305

    That should be a simple trace of the code that performs the :

    • Insert/Update/Delete
    • Check that table(s) for triggers that may fire
    • Check to see if there are any jobs that look for changes/inserts/deletes and follow their code

    It is a manual process that should not be too difficult as long as you are maintaining decent control of the code.

    Please note that no matter what you come up with it probably won't be 100% accurate due to the fact that you probably (assuming from the question) have rogue programs that run multiple different ad-hoc SQL statements that you have no idea of.

    Another thing you may want to investigate is the use of SQL profiler to determine what SQL statements are being fired.......

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • September 17, 2004 at 11:15 am

    #523540

    The best tool for this is sql profiler as mentioned by AJ Ahrens

  • September 17, 2004 at 11:34 am

    #523544

    Thank you

    Every bit helps

     

     

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

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