Last Update Date

Ignition
1

I was looking for an easy way to display the last update date for a table in my database…

This was a quick way I found to do so…

Just a SQL query on the text property of a Label object (my DB is MS SQL Server 2008)

SELECT ‘Last Update - ’ + CONVERT(VARCHAR(12), last_user_update, 107) AS [Mon DD, YYYY]
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( ‘’)
AND OBJECT_ID=OBJECT_ID(’’)