if you have access to the application source code which is using this database, then you can debug the application and find out when the records are inserted.

You could also use profiler to see which stored procedures are being called in the application process.

It would be really great if you could throw some more light on your requirement.

🙂