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

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

CREATE TABLE #LastAccess (DatabaseName	sysname,
			TableName	sysname,
			LastSelect	datetime)
						  
DECLARE @SQL varchar(max)
SET @SQL = 'USE ?; '
                    + 'WITH LastActivity (ObjectID, LastAction) AS '
                    + '( '
                    + 'SELECT object_id, '
                                + 'last_user_seek as LastAction '
                            + 'FROM sys.dm_db_index_usage_stats '
                            + 'WHERE database_id = db_id(db_name()) '
                        + 'UNION SELECT object_id, '
                                            + 'last_user_scan as LastAction '
                                        + 'FROM sys.dm_db_index_usage_stats '
                                        + 'WHERE database_id = db_id(db_name()) '
                        + 'UNION SELECT object_id, '
                                            + 'last_user_lookup as LastAction '
                                    + 'FROM sys.dm_db_index_usage_stats '
                                    + 'WHERE database_id = db_id(db_name()) '
                    + ') '
                    + 'INSERT INTO #LastAccess '
                    + 'SELECT DB_NAME() AS DatabaseName, '
                                + '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) '

EXEC sp_MSforeachdb @SQL

SELECT * FROM #LastAccess