Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010

    Smile Unanswered: active transaction tables.

    Hi guys,

    I have been allocated to a new completed project for maintenance work and i don't know the tables our application is hitting. There are few static master tables and few dynamic tables where data are consistently coming from customer (client side) and are hitting few tables. I want to know the way i can see those tables where data are hitting. i mean, suppose 10 customers are entering data (a transaction) into 3 tables. Now, how do i see those 3 tables where data are getting entered.

    Kindly provide me a solution, it's very urgent.

    Thanks a lot.

  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    You may use SQL Server Profiler tool. There you have the option to filter the results by Application Name.
    How to: Filter Events in a Trace (SQL Server Profiler)
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts