How to Detect Modified Pages In SQL Server Tables?
Lincoln Burrows ~
Modified: August 6th, 2015 ~ ~ 1 Minute Reading
- This topic has 4 replies, 2 voices, and was last updated 10 years ago by .
Viewing 5 posts - 1 through 5 (of 5 total)
-
Posts
-
On which SQL Server Version you are working?
use following query for the detection of last modification:
SELECT [name],create_date,modify_date FROM sys.tablesrun the following query to find the last update
SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,* FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID( 'AdventureWorks') AND OBJECT_ID=OBJECT_ID('test')
Viewing 5 posts - 1 through 5 (of 5 total)
- You must be logged in to reply to this topic.