Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
denialparl
Starting Member
5 Posts |
 Posted - 2014-01-06 : 05:47:32
|
| How can I track change data which is more than 30 days old on SQL server 2008? Also, can I analyze the time of modification, which column is modified recently? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-06 : 06:39:56
|
| Do you've CDC enabled for the table? Or atleast an audit/history table setup? Does it habve audit trail columns like lastmodified?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
denialparl
Starting Member
5 Posts |
Posted - 2014-01-07 : 02:31:41
|
| Yes, CDC is enabled. But, can you please brief me about where can I check the last modification ? |
|
|
|
nickeyclayton
Starting Member
4 Posts |
Posted - 2014-01-07 : 06:26:55
|
| You can track what data has changed in database by using SQL Server audit tool.Please have a look at these links: http://www.sqlserveraudit.organdhttp://technet.microsoft.com/en-us/library/cc280462%28v=sql.105%29.aspx |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
denialparl
Starting Member
5 Posts |
Posted - 2014-01-08 : 06:16:08
|
quote:
Originally posted by nickeyclayton
You can track what data has changed in database by using SQL Server audit tool.Please have a look at these links: http://www.sqlserveraudit.organdhttp://technet.microsoft.com/en-us/library/cc280462%28v=sql.105%29.aspx
Checking both links for better conclusion. However, I am not much familiar with scripting but will try if the provided tool can make me smart to do such jobs promptly. |
|
|
|
|
|
|
Track old records and data in SQL server 2008