USE tempdb;
GO

-- Identificar objetos temporales en tempdb
SELECT
    OBJECT_NAME(object_id) AS [Object Name],
    user_object_id,
    type_desc AS [Type],
    total_pages * 8 / 1024 AS [Size MB]
FROM
    sys.dm_db_session_space_usage
WHERE
    database_id = DB_ID('tempdb');
GO