<div>
1.Can I check the transaction logs through SQL statement.<br />
<br />
2. Just add record only. May you give any details of setup, trigger and write audit table.<br />
<br />
Thanks.
</div>


1.Can I check the transaction logs through SQL statement.

2. Just add record only. May you give any details of setup, trigger and write audit table.

Thanks.

<div>
<div class="content wysiwyg-content">
Many clients may import data into DB.<br />
One of the client is Admin, and now he want to know everyday any data has been imported.<br />
<br />
Is there any way to do it without adding extra table, just know the table change.<br />
<br />
Thanks
</div>
</div>


Many clients may import data into DB.
One of the client is Admin, and now he want to know everyday any data has been imported.

Is there any way to do it without adding extra table, just know the table change.

Thanks

How to know if any data has coming into a table

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.