May 7, 2018 at 12:56 am
I have an SQL server and we needs to monitor a specific table with 10k records for any insert update or delete changes in that table.
We dont have any time stamp in our table and CDC were not enabled.
Now,is it possible to find any changes in that table ?
May 7, 2018 at 1:00 am
aloshya - Monday, May 7, 2018 12:56 AMI have an SQL server and we needs to monitor a specific table with 10k records for any insert update or delete changes in that table.We dont have any time stamp in our table and CDC were not enabled.
Now,is it possible to find any changes in that table ?
Can you please post the DDL (create table) script for the table, sample data as an insert statement and more details on what you are looking for?
😎
May 7, 2018 at 7:55 am
No. SQL Server itself does not store that type of info. It would be too much overhead on the system.
If the table has a unique key, you could use triggers to store the unique keys that get added or changed.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
May 7, 2018 at 5:01 pm
The only way I can think of is adding an updated column with a trigger that updates it on after update.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply