--SELECT name AS DBName, dbid as DBId, SUSER_SNAME(sid) AS Owner, crdate as CreationDate, cmptlevel AS CompatibilityLevel FROM master.dbo.sysdatabases


Declare @temp varchar(50), @DBName_ varchar(100), @TBName_ varchar(100), @Size_ float
Declare @sql varchar(8000),  @proc varchar(8000)


Set @sql = ''
Set @proc = ''
--Création de la table temporaire
CREATE TABLE #sp_spaceused (TBName varchar(150), NbRows bigint, SReserved varchar(50), SData varchar(50), Sindex varchar(50), SFree varchar(50))

Declare cursor_db CURSOR
--On liste les basses des données
For  SELECT name AS DBName FROM master.dbo.sysdatabases
OPEN cursor_db
	Fetch next from cursor_db
	INTO @DBName_
		WHILE @@Fetch_STATUS = 0
		BEGIN
			--Print 'SELECT table_name FROM information_schema.tables WHERE table_Catalog= ''' + @DBName_ + ''' '
			--Print 'USE ' + @DBName_ 
			--On liste les tables...
			execute('USE ' + @DBName_ )
			set @sql = 'Declare cursor_size CURSOR'
			set @sql = @sql + ' For  SELECT table_name FROM ' + @DBName_ + '.information_schema.tables WHERE Table_Type = ''BASE TABLE'''
			--For  SELECT table_name FROM information_schema.tables WHERE table_Catalog= @DBName_ and Table_Type = 'BASE TABLE'			
			Execute(@sql)
			OPEN cursor_size
				Fetch next from cursor_size
				INTO @TBName_
					WHILE @@Fetch_STATUS = 0
					BEGIN			
						if rtrim(@TBName_) <> ''
						BEGIN
						--insert into #sp_spaceused execute sp_spaceused @TBName_
						execute('USE ' + @DBName_)
						--Go
						set @proc = 'insert into #sp_spaceused execute sp_spaceused ''' + @DBName_ + '.dbo.' + @TBName_ + ''''
						print @proc
						execute(@proc)
						END
					Fetch next from cursor_size
				INTO @TBName_
				END
			CLOSE cursor_size;
			DEALLOCATE  cursor_size;

		Fetch next from cursor_db
		INTO @DBName_
		END
	CLOSE cursor_db;
DEALLOCATE  cursor_db;

select * from #sp_spaceused
Drop Table #sp_spaceused


execute sp_spaceused @TBName_