How to check data is inserted deleted or updated in ms sql database
By Junaid A   Posted on November-07-2022
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   07-Nov-2022
Views 44
Share This with your friend by choosing any social account
Comments
Your Comments
You may also read following recent articles
![]() |
7 Ways to Retain More of Every Book You Read!
04-Feb-2023 11 |
![]() |
Top 5 Most Tech Skills for 2023!
04-Feb-2023 10 |
![]() |
Rupee Drops to Historic Low After Comments From Dar, PM Shehbaz Cause Market to Panic!
03-Feb-2023 18 |
![]() |
What Is Technical SEO? Basics and 10 Best Practices!
03-Feb-2023 24 |
|
Top 10 Most Important IT Skills in 2023!
02-Feb-2023 36 |
![]() |
How To Create A Content Strategy Framework!
02-Feb-2023 18 |
![]() |
Can GPT-3 pay in the future?!
02-Feb-2023 7 |
![]() |
What is digital marketing? !
02-Feb-2023 46 |
|
Top Software Testing Trends in 2023!
01-Feb-2023 67 |
![]() |
How To Make Money on YouTube in 2023!
31-Jan-2023 36 |
![]() |
The 6 Best Entry-Level Sales Jobs To Start Your Career!
31-Jan-2023 23 |
![]() |
Affiliate Marketing Program for Beginners!
31-Jan-2023 5 |