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

Posted on 2011-10-15
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
    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

    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

    You can use SQL Server Profiler, which allows you to capture the set of statements executes when you post a voucher or any transaction.

    Author Comment

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

    Accepted Solution


    Author Closing Comment

    solution is correct. thanks

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    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.

    733 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