Tablo Kullanımlarını Getiren Sql [sql server 2005] (Shows usage of tables)

CREATE TABLE #temp_Table ( tablename sysname ,row_count INT ,reserved VARCHAR(50) collate database_default ,data VARCHAR(50) collate database_default ,index_size VARCHAR(50) collate database_default ,unused VARCHAR(50) collate database_default )
declare @sql varchar(max)declare cSql CURSOR FOR select name [SQL]from sys.tables
OPEN cSqlFETCH NEXT FROM cSql INTO @sql WHILE @@FETCH_STATUS = 0 BEGIN INSERT INTO #temp_Table EXEC sp_spaceused @sql, false; -- select @sql FETCH NEXT FROM cSql INTO @sql END CLOSE cSql DEALLOCATE cSql select * from #temp_Tableorder by row_count descdrop TABLE #temp_Table