how to check modification in ms sql database
- MS Sql Server
- 269
- July-25-2022
- by Junaid A
--how to check modification in ms sql database
-- option
SELECT name, modify_date from sys.objects where type ='U' order by modify_date desc
-- option 1
select
object_name(object_id) as OBJ_NAME, *
from
sys.dm_db_index_usage_stats
where
database_id = db_id(db_name())
Order by
dm_db_index_usage_stats.last_user_update desc
---option 2
SELECT name [TableName], Create_date [CreateDate], modify_date [LastUpdate] , type [type] FROM sys. all_objects
--WHERE type = 'U'
ORDER BY modify_date DESC;
Search term
check changes in db
check changed in database
check modifications in database
