I am using MS SQL Server 2008. I have a table in a database, in which records are being inserted and deleted.
Initially the table is empty. A Java program (probably) inserts few records in it. Another Java program quickly access the table and deletes the records (All the records which were inserted). And then I manually run a
select query on the table. So basically I can see only the "initial" and final state of the table, both of in which the table is empty.
I need to know that is there a way by which I can see those records, or at least check if something is being inserted/deleted?
Any help is appreciated.