SQL Server - Number of Insert,Update and Select happened in a database within 24 hours
Asked By santhosh on 15-Oct-12 03:36 AM
Kindly provide me a query to find the number of Insert,Update and Select happened in a database within 24 hours
Thanks in Advance,
Robbe Morris replied to santhosh on 15-Oct-12 09:26 AM
No such audit trail is kept for you. You'd need to create a schema and manage all of this yourself. That said, all of this is kept in the Log file but I'm not aware of a native SQL access to it. You may need to purchase a SQL Log reader from a third party.
Venkat K replied to santhosh on 15-Oct-12 01:44 PM
You can use the CDC (Change Data Capture) feature in SQL Server 2008, or you need to write a trigger wherein you can maintain the code a table which increments the value everytime you do a DML operations.