I have a query that is supposed to return table name and last time it was touched and display the tablename and last update
for some reason under table name... it is returning null as its value
can someone correct the query please
SELECT OBJECT_NAME(OBJECT_ID) AS TableName, last_user_update
WHERE database_id = DB_ID( 'DATBASENAME')
AND last_user_update >= '2015-04-13 13:07:00'