How to Check Database Status

Question

Dear Experts,   How to Know the database is updated by inserted or deleted or modified     please help

Jignesh Kumar · Accepted Answer

Hi Yesubabu,   You can write trigger for table once any insert or update or delete happens trigger get call at backend by sql. You can write you logic inside trigger.   Please go through sql trigger link,   https://www.aspsnippets.com/Articles/Simple-Insert-Update-and-Delete-Triggers-in-SQL-Server-with-example.aspx    http://www.gurujipoint.com/2017/09/trigger-in-sql-server-insert-update.html

yesubabu k · Answer

Tanque Sir,   but  i am not developing application, i have not rights to modify database i have to retrive the data which is updated then i will process    that is why how can i find the  database is updates or deleted or inserted

Madan Shekar · Answer

Query the sys.objects table to find the objects that changed and filter by modify_date and type; U = User table, P = Stored procedure. select * from sys.objects where (type = 'U' or type = 'P') and modify_date > dateadd(m, -3, getdate()) if it helps please mark as answer

Salman Beg · Answer

You can use created date/ modified date for that. Otherwise you can use bit column like IsCreated,Is modified or IsDeleted like this. But Everytime you need to update these column values in DB. Thanks

yesubabu k · Answer

Super Sir