Click here to Skip to main content
15,922,315 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I wanted to use Change tracking mechanism in SQL server to track insert/update/delete operation in tables.
I searched lot of forums on how to clear the cache once i processed the particular record from change table. The answer that I got is I need to Disasble and Enable the change tracking on table to clear the cache. Is it a good practice/solution to do this?
What happenes if records are added/updated/deleted during the time of Disabling/Enabling the tracking again?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900