1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
CREATE TABLE #toto
(name_ varchar(50),
rows_ int,
reserved varchar(50),
data varchar(50),
index_size varchar(50),
unused varchar(50))
DECLARE @NAME varchar(50)
DECLARE curseur CURSOR FOR
select name from sysobjects where type = 'U'
OPEN curseur
FETCH NEXT FROM curseur INTO
@NAME
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO #toto (name_,rows_,reserved,data,index_size,unused)
EXEC sp_spaceused @NAME
FETCH NEXT FROM curseur INTO
@NAME
END
Close curseur
DEALLOCATE curseur
select * from #toto order |
Partager