How to find the date and time of last updated table?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / durga prasad

6 Answers
9704 Views
Teledata, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to find the date and time of last updated table? ..

Answer / monal

USE TRIGGER OR ADD DATETIMESTAMP COLUMN IN A TABLE WITH
DEFAULT VALUE OF GETDATE()

Is This Answer Correct ?

9 Yes

2 No

How to find the date and time of last updated table? ..

Answer / sanjeev kumar

SELECT OBJECT_NAME(OBJECT_ID) AS tablename,
last_user_update
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'your_database_name')
and user_updates>0
order by last_user_seek desc

Is This Answer Correct ?

3 Yes

0 No

How to find the date and time of last updated table? ..

Answer / smitha

select name,create_date,modify_date from sys.tables
order by modify_date desc

Is This Answer Correct ?

5 Yes

3 No

How to find the date and time of last updated table? ..

Answer / vidit tyagi

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName,
last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'DataBaseName')
AND OBJECT_ID=OBJECT_ID('TableName')

Is This Answer Correct ?

1 Yes

0 No

How to find the date and time of last updated table? ..

Answer / ram

USE TRIGGER OR ADD DATETIMESTAMP COLUMN IN A TABLE WITH
DEFAULT VALUE OF GETDATE()

Is This Answer Correct ?

1 Yes

1 No

How to find the date and time of last updated table? ..

Answer / siddharthapenchala

select scn_to_timestamp(max(ora_rowscn)) from <TN>

Is This Answer Correct ?

0 Yes

0 No

Post New Answer