• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • 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 CroweDatabase AdministratorCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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