Sql dmv to capture updates

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

Source: stackoverflow.com

Similar codes

-1 vote148 views1 answer
Su: Authentication failure mysql
SQL
2 votes110 views1 answer
Latest record in sql
SQL
0 vote164 views2 answers
PostgreSQL having
SQL
3 votes146 views1 answer
Get current month last date in sql server
SQL
1 vote162 views1 answer
Top 10 rows in mysql
SQL
2 votes147 views1 answer
Add default sql server
SQL
0 vote166 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote163 views1 answer
Merge clause with inner join
SQL
1 vote147 views1 answer
Mysql find most common value
SQL
0 vote149 views1 answer
Mysql default uuid
SQL