dm_os_buffer_descriptors

This is a view in the mssqlsystemresource database. Returns information about all data pages that are in the SQL Server buffer cache, excluding free, stolen, or erroneously read pages. SQL Server 2005 tracks anything put into the buffer cache using buffer descriptors. You can easily scope the results to show one or all database and one or all of the objects within the database.

CREATE VIEW sys.dm_os_buffer_descriptors AS  SELECT *  FROM OpenRowset(TABLE SYSBUFFERDESCRIPTORS)