question

Kiran 1 avatar image
Kiran 1 asked

Does INSERT/DELETE change the modified date?

I have a database and i want to know when a table was last modified by INSERT/DELETE? Please advise

sql-server-
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

You could look at the last_user_update column of DMV sys.dm_db_index_usage_stats for index_id 0 (HEAP) or 1 (Clustered index) for the table you want


10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.