Post reply

Tables affected by a particular action

  • May 5, 2006 at 7:24 am

    #114529

    Is there any way to find out what are the tables affected by a particular action from the front end...May be with sql server logs or some other technique...

    Any help will be greatly appreciated...

    Thanks

    Jol

    Kindest Regards,

    Joel

  • May 5, 2006 at 9:32 am

    #636291

    Joel,

    Can you provide some more details?  If the app is executing dml statements dynamically, the tables will be named in the app itself.  If it's executing a stored procedure, the tables will be named in the procedure.

    Greg

    Greg

  • May 5, 2006 at 9:44 am

    #636299

    Thanks for the reply Charles...

    Actually the front-end is a third party Software so we cant get any information from the app...I have access to the database though..

    Is there any feature in SQL server that will let me determine all the tables affected by an insertion of record from the front end...

    Kindest Regards,

    Joel

  • May 5, 2006 at 9:53 am

    #636311

    Run profiler to record actions in the database while the application is being used.  Be sure to capture the object name and type.

    Greg

    Greg

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

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