Probam , da vidim kada su tablice u jednoj i drugoj update-ane i pokupiti iz te dvije najnovije tablice : nesto ovako
Code:
SELECT OBJECT_NAME(object_id) AS DatabaseName, last_user_update, database_id, object_id, user_updates, last_user_scan, system_updates, last_system_seek,
last_system_scan, last_system_lookup, last_system_update
FROM sys.dm_db_index_usage_stats
ORDER BY last_user_update DESC
SELECT OBJECT_NAME(object_id) AS DatabaseName, last_user_update, database_id, object_id, user_updates, last_user_scan, system_updates, last_system_seek,
last_system_scan, last_system_lookup, last_system_update
FROM sys.dm_db_index_usage_stats
ORDER BY last_user_update DESC
ali mi bas i ne ide zarukom : Da li mi je dobar pristup ili da me njam logiku , i da li ko ima da pomogen ??
hvala