Determine Last Modification Datetime for an Azure Table
Posted
by
embeddedprogrammer
on Stack Overflow
See other posts from Stack Overflow
or by embeddedprogrammer
Published on 2012-12-06T16:53:43Z
Indexed on
2012/12/06
17:04 UTC
Read the original article
Hit count: 210
I am developing an application which may be hosted on a microsoft sql server, or on Azure SQL, depending upon the end user's wishes.
My whole system works fine with the exception of some WCF functions which determine the last modification time of tables using the following technique:
SELECT OBJECT_NAME(OBJECT_ID) as tableName,
last_user_update as lastUpdate
FROM mydb.sys.dm_db_index_usage_stats
This query fails in Azure. Is there any analogous way to get table last modification dates from Azure's sql?
© Stack Overflow or respective owner