How can we find update information on columns
-
How can we find update information on columns that frequently gets updated from previous days.
One ways is to use date time functions included in columns.
Can we use Change data capture to capture the data that is changed from previous days.
or do we have any other method to find frequently updated columns.
-
CDC is a good option to work with in such scenario. Check the below link for details on what CDC is and how this can be implemented.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
Unless you have some form of custom auditing which is already switched on, getting previous update information will not be possible.
However, if you enable things like CDC or write your own customer auditing you will be able to see what is being updated from the moment you enable such auditing.
-
Thank you all..Vll try and let u know..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply