<div>
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. &nbsp;That is, provided all the tables have promary keys or at the every least a single unique index.
</div>


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.

<div>
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.
</div>


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.

<div>
You can use <a href="http://msdn.microsoft.com/en-us/library/ff650699.aspx" rel="ugc nofollow">SQL Server Profiler</a>, which allows you to capture the set of statements executes when you post a voucher or any transaction.
</div>


You can use SQL Server Profiler [http://msdn.microsoft.com/en-us/library/ff650699.aspx], which allows you to capture the set of statements executes when you post a voucher or any transaction.

<div>
we are not so familiar with this profiler. can you give any example
</div>


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

<div>
solution is correct. thanks
</div>


<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.