Find no of rows inserted/updated/deleted from a table of SQLServer
I have database in SQL Server. there are many tables present. The database is CDC activated. I would like to see how many rows are inserted/updated/deleted into the table/tables in a day. Are there any system table/tables present that keep track of these changes and we can query from there (without causing any performance issues)? … Read more