WITH LastActivity (ObjectID, LastAction) AS
    (
    SELECT OBJECT_ID AS TableName,
                last_user_seek AS LastAction
        FROM sys.dm_db_index_usage_stats u
        WHERE database_id = DB_ID(DB_NAME())
        UNION
    SELECT OBJECT_ID AS TableName,
                last_user_scan AS LastAction
        FROM sys.dm_db_index_usage_stats u
        WHERE database_id = DB_ID(DB_NAME())
        UNION
    SELECT OBJECT_ID AS TableName,
                last_user_lookup AS LastAction
        FROM sys.dm_db_index_usage_stats u
        WHERE database_id = DB_ID(DB_NAME())
    )
SELECT OBJECT_NAME(so.OBJECT_ID) AS TableName,
            MAX(la.LastAction) AS LastSelect
    FROM sys.objects so
            LEFT
            JOIN LastActivity la
            ON so.OBJECT_ID = la.ObjectID
    WHERE so.TYPE = 'U'
        AND so.OBJECT_ID > 100
    GROUP BY OBJECT_NAME(so.OBJECT_ID)
    ORDER BY OBJECT_NAME(so.OBJECT_ID)

We walk in the dark places no others will enter
We stand on the bridge and no one may pass