Aug 31 2023 07:13 AM
I have database in sqlserver.there are many tables present.database is CDC activated.Huge transactions happen in multiple tables in a day.I would like to see how many rows are inserted/updated/deleted into the table/tables in a day.
Is there any system table/tables present which keep tracks of these update and we can query from there(without causing any performance issue in db)?
Sep 01 2023 11:08 AM
Hi @Debasis2023
in CDC you cannot keep track of the "when" rows got inserted/deleted/updated . it is just focuded on the values that were changed
what is change data capture (CDC) ?
In order to do what you need , you have to take a look to SQL Temporal Tables
"Temporal tables (also known as system-versioned temporal tables) are a database feature that brings built-in support for providing information about data stored in the table at any point in time, rather than only the data that is correct at the current moment in time."
Hope it helps
Regards
Javier
Sep 04 2023 12:17 AM