HOw do I track that which tables got effected after running a SQL transection

Posted on 2011-10-15
Medium Priority
Last Modified: 2012-05-12
I have a using SAGE PASTEL ERP which is giving us access to its tables. I want to know when I posted any voucher or any transection. it affect or change which tables. I am using SLQ server 2005 and on other server 2008. if there anay software or any way to know this?
Question by:mahmood66
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36973731
You could create a backup of the database, make the change and then use something like Red-Gate's SQL Data Compare to compare the differences.  That is, provided all the tables have promary keys or at the every least a single unique index.
LVL 25

Expert Comment

ID: 36974423
Or run a profiler in both the servers and filter with the host name with the name of the pc from which you are updating the data. Hope there is no intermediate web-service involved.
LVL 15

Expert Comment

ID: 36977934
You can use SQL Server Profiler, which allows you to capture the set of statements executes when you post a voucher or any transaction.
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database


Author Comment

ID: 36978048
we are not so familiar with this profiler. can you give any example
LVL 15

Accepted Solution

Anuj earned 1500 total points
ID: 36978146

Author Closing Comment

ID: 37029558
solution is correct. thanks

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

864 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