Monday, 21 November 2016

How to Find when the Table was last refreshed in SQL Server

How to Find when the Table was last updated by user in SQL Server

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, Last_User_Update,*
FROM sys.dm_db_Index_Usage_Stats
WHERE Database_Id = DB_ID( 'TAMATAM') --Database name need to pass here
And Object_Id=
Object_Id('TBL_Weekly_Data') --Table name need to pass here

---------------------------------------------------------------------------

SELECT Distinct Last_User_Update
FROM sys.dm_db_Index_Usage_Stats
WHERE Object_id=Object_id('[dbo].[
TBL_Weekly_Data]')

Thanks,
TAMATAM

No comments:

Post a Comment

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts