IF EXISTS (SELECT * FROM tempdb..sysobjects
WHERE id = object_id(N'[tempdb]..[#UnwantedTables]'))
drop table #UnwantedTables
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects
WHERE id = object_id(N'[tempdb]..[#tablelist]'))
drop table #tablelist
GO
create table #tablelist
(
dbname sysname
,tablename varchar(256)
,test varchar(max)
)

Create table #UnwantedTables
(
tblname varchar(256),
Row int,
reserved varchar(32),
data varchar(16),
index_size varchar(16),
Unused varchar(16)
)


DECLARE @statement nvarchar(max)
SET @Statement = 'USE [?];
SELECT DISTINCT
	''[''+DB_NAME()+'']'' AS [Current Database]
	,OBJECT_NAME(I.OBJECT_ID) AS OBJECTNAME
	,''[''+DB_NAME()+''].dbo.sp_spaceused[''+ss.name+''.''+OBJECT_NAME(I.[object_id])+'']'' as test
From sys.indexes I
inner join sys.objects o 
	on I.[object_id]=O.[Object_id]
inner join sys.schemas as ss
	on ss.[schema_id]=o.[schema_id]
left join (Select distinct [object_id] from sys.dm_db_index_usage_stats) as S
	on S.[object_id]=I.[object_id]	
WHERE s.[object_id] is NULL
AND O.TYPE = ''U'''

insert into #tablelist
exec sp_msforeachdb @statement

DECLARE Cur_UnWantedTbls CURSOR READ_ONLY
FOR select test from #tablelist where dbname not in
('[master]','[msdb]','[tempdb]','[model]')

DECLARE @objectName varchar(512)
OPEN Cur_UnWantedTbls
	FETCH NEXT FROM Cur_UnWantedTbls INTO @objectName
	WHILE (@@fetch_status <> -1)
	BEGIN
		IF (@@fetch_status <> -2)
		BEGIN
			insert into #UnwantedTables 
			exec ( @objectName)
		END
	FETCH NEXT FROM Cur_UnWantedTbls INTO @objectName
	END
CLOSE Cur_UnWantedTbls
DEALLOCATE Cur_UnWantedTbls

select distinct @@servername, DBNAME, TABLENAME, LEFT(RESERVED, LEN(RESERVED)-2) ReservedInKB, 
(select create_Date from sys.databases where name = 'tempdb') RecycledTime
from #tablelist inner join #UnwantedTables on tblname = tablename
where reserved <> '0 KB'