I have a database and i want to know when a table was last modified by INSERT/DELETE? Please advise
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
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
15 People are following this question.
Validate that Update was successful
sys.database_principals = null, removal with T-SQL
Running DBCC CHECKDB in a Passive Node
What to do after my sql server primary file group has reached 10gb?
SQL database in recovery pending state