apollo7
asked on
SQL query that lists the entire database by date modified
Does anyone have a SQL query that queries the entire database and lists the records by date modified? I am looking for a count of how many records in each table was modified in 2018, 2017 and so on back to 2008.
Thanks
Thanks
Are you using Change Tracking, Change Data Capture or Versioning on your database?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank everyone for the information, I have gone through about 100 tables and did a count based Modified On date. This field is not available in every table, so I had to manually select the tables to review.
The information you all provided was enlightening so I know how this needs to be setup for future use.
The information you all provided was enlightening so I know how this needs to be setup for future use.
ASKER
I have split the points to everyone that responded to my question, thanks for the assistance..