Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Archives: March 2014

SQL Server – How to get last access/update time for a table

Modify date and create date for a table can be retrieved from sys.tables catalog view. When any structural changes are made the modify date is updated. It can be queried as follows:

USE [SqlAndMe]

SELECT    [TableName] = name,
FROM    sys.tables
WHERE    name = 'TransactionHistoryArchive'


  Read more

2 comments, 1,490 reads

Posted in SQL and Me on 11 March 2014