I ended up solving this problem by using the below query instead. Even though access to the system views appears to be the same, my network service account does not have permissions issues.

SELECT TOP 1 LASTUPDATED FROM (

SELECT CONCAT(S.name, '.', B.Name) AS FullName, MAX(STATS_DATE (ID,INDID)) AS LASTUPDATED

FROM SYS.SYSINDEXES AS A

INNER JOIN SYS.OBJECTS AS B ON A.ID = B.OBJECT_ID

INNER JOIN SYS.SCHEMAS AS S ON s.schema_id = b.schema_id

WHERE B.TYPE = 'U' AND STATS_DATE (ID,INDID) IS NOT NULL

GROUP BY B.Name, S.name ) AS Q

WHERE (FullName = @Table_0)) ORDER BY LASTUPDATED DESC