sys.dm_db_index_usage_stats:ast_us er_update value i s NULL

I am getting the value "last_user_update" as Null by using below query for only some tables.What is the meaning if it is Null.One column got changed and I want to know when it was changed.

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

Kindly help me on this.

<o:p></o:p>

September 10th, 2015 3:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics