Find out what tables ar being updated.

Posted on 2005-05-03
Last Modified: 2008-03-17
We use an off the shelf inventory system here, the problem is the item import utility is limited as to what fields are being updated. What I need to know is how do I find out what tables are being updated so I can create my own import utility.

This system uses Microsoft SQL Server as it's database. Is their a way I can check the transaction log to find out, or is their another way if that is not possible?

Question by:sloanish
    LVL 34

    Expert Comment

    by:Brian Crowe
    You could try running the profiler and watching while the application is in use to see what kind of actions are taken
    LVL 18

    Expert Comment

    I would suggest that the product documentation would state which tables if it is designed to be hacked about with.   If i were you i would check that you are not breaching the licence agreeement before embarking.
    LVL 13

    Accepted Solution

    You can put DELETE,INSERT,UPDATE AFTER TRIGGERS on your tables. I am not sure what kind of code in trigger to use.

    Simple UPDATE LOGTABLE SET USED=1 WHERE TABLENAME='SomeTable' can result in locking.
    INSERT INTO  LOGTABLE (TABLENAME,USED) VALUES ('SomeTable',1) can result in large table.
    RAISERROR with alert defined with long delay can change application logic.
    LVL 13

    Expert Comment

    would you be so kind to respond?

    Author Comment

    Sorry for the delayed reply,

    I have found a utility that allowed me to view the transaction log from Lumigent and that seemed to have solved the problem for me. Though for answering the question I would like to giv e the points to Ispaleny.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now