Table update tracking

Track table updates

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'bdc')
AND OBJECT_ID=OBJECT_ID('dwh_salesdata_ace')

modify datetime in sql server

DATEADD(hh, 1, last_user_update)

track table structure changes

SELECT name, [modify_date] FROM sys.tables