Home » Blog » Topic » How to Detect Modified Pages In SQL Server Tables?

How to Detect Modified Pages In SQL Server Tables?

Lincoln Burrows ~ Modified: August 6th, 2015 ~ ~ 1 Minute Reading

Home Forums How to Detect Modified Pages In SQL Server Tables?

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #431 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    Is there a way to check if an SQL Server table was modified since a certain moment?

    #434 Score: 0
    Stephen West
    Moderator
    4 pts

    On which SQL Server Version you are working?

    #435 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    I am Using SQL Server Version 2005

    #437 Score: 0
    Stephen West
    Moderator
    4 pts

    use following query for the detection of last modification:
    SELECT [name],create_date,modify_date FROM sys.tables

    #775 Score: 0
    Stephen West
    Moderator
    4 pts

    run 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.