How to know if any data has coming into a table

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
turbot_yuAsked:
Who is Participating?
 
Azhrei1Commented:
You could check the transaction logs? :)
0
 
Atdhe NuhiuCommented:
Are we talking about adding records or update,add and delete?

If you only add the number of records would be the clue.

Why do you not want to add a table. The  best way would be to set up an audit table and triggers on your table on update add delete. to write to this audit. Then you know exactly what is happening
0
 
turbot_yuAuthor Commented:
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.
0
 
Atdhe NuhiuCommented:
Thanks
0
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.

All Courses

From novice to tech pro — start learning today.