• For the cleanup of unused objects, does someone have a script or knows a DMV to indicate when a view or function was last accessed?

    I've found a script, but this only returns the last_execution_time for Stored Procedures.

    Select *

    from sysobjects S

    left join sys.dm_exec_procedure_stats X on X.object_id = S.id

    where S.xtype in ('P' ,'X', 'FN', 'V')