How to check data is inserted deleted or updated in ms sql database
By Junaid A Posted on October-03-2023 130
General
Problem:
Sometime, we are not sure, which database table are being used.so we want check which tables are in use
Solution:
SELECT
[db_name] = d.name
, [table_name] = SCHEMA_NAME(o.[schema_id]) + '.' + o.name
, s.last_user_update
FROM sys.dm_db_index_usage_stats s
JOIN sys.databases d ON s.database_id = d.database_id
JOIN sys.objects o ON s.[object_id] = o.[object_id]
WHERE o.[type] = 'U'
AND s.last_user_update IS NOT NULL
AND s.last_user_update BETWEEN DATEADD(wk, -1, GETDATE()) AND GETDATE()
By asifjans 03-Oct-2023
Views 130
