• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Find out what tables ar being updated.

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?

1 Solution
Brian CroweCommented:
You could try running the profiler and watching while the application is in use to see what kind of actions are taken
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.
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.
would you be so kind to respond?
sloanishAuthor Commented:
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

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now