[Solved] SQL Server: Get last user update time for tables is returning NULL

Hi tsakumar81,

Use the STATS_DATE function.

Refer below query.

SQL

CREATE FUNCTION [dbo].[ufnGetLastUpdatedDate]
(
    -- Add the parameters for the function here
    @Tablename VARCHAR(100)
)
RETURNS DATETIME
AS
BEGIN
    -- Declare the return variable here
    DECLARE @lastupdated DATETIME
  
    -- Add the T-SQL statements to compute the return value here
    SET @lastupdated = (SELECT TOP 1 STATS_DATE(object_id, stats_id) AS last_user_update 
						FROM sys.stats 
						WHERE OBJECT_ID=OBJECT_ID(@Tablename))
  
    -- Return the result of the function
    RETURN @lastupdated
END
GO

For more details on STATS_DATE function refer below link.

https://learn.microsoft.com/en-us/sql/t-sql/functions/stats-date-transact-sql?view=sql-server-ver16&redirectedfrom=MSDN

Another sql server expert said that is has happened due to database server restart.