22,207
社区成员
发帖
与我相关
我的任务
分享
insert into #tb
exec sp_MSforeachtable @command1="sp_spaceused '?'"
--先建一个临时表
create table #t(
name nvarchar(128),
rows char(11),
reserved varchar(18),
data varchar(18),
index_size varchar(18),
unused varchar(18)
)
insert #t exec sp_MSforeachtable @command1="sp_spaceused '?'"
--在存储过程中加入
create table #tb()
insert into #tb select ……
select * from #tb
use ReportServer
go
create table #(name nvarchar(100),rows int,reserved nvarchar(20),data nvarchar(20),index_size nvarchar(20),unused nvarchar(20))
go
insert into # exec sp_MSforeachtable @command1="sp_spaceused '?'"
select * from #
go
drop table #
/*
name rows reserved data index_size unused
---------------------------------------------------------------------------------------------------- ----------- -------------------- -------------------- -------------------- --------------------
ConfigurationInfo 17 32 KB 8 KB 24 KB 0 KB
Catalog 1 64 KB 8 KB 56 KB 0 KB
UpgradeInfo 0 0 KB 0 KB 0 KB 0 KB
ModelDrill 0 0 KB 0 KB 0 KB 0 KB
ModelPerspective 0 0 KB 0 KB 0 KB 0 KB
CachePolicy 0 0 KB 0 KB 0 KB 0 KB
Users 3 32 KB 8 KB 24 KB 0 KB
DataSource 0 0 KB 0 KB 0 KB 0 KB
Policies 2 16 KB 8 KB 8 KB 0 KB
ModelItemPolicy 0 0 KB 0 KB 0 KB 0 KB
SecData 2 48 KB 24 KB 24 KB 0 KB
Roles 8 32 KB 8 KB 24 KB 0 KB
PolicyUserRole 4 32 KB 8 KB 24 KB 0 KB
Event 0 0 KB 0 KB 0 KB 0 KB
ExecutionLog 0 0 KB 0 KB 0 KB 0 KB
Subscriptions 0 0 KB 0 KB 0 KB 0 KB
ActiveSubscriptions 0 0 KB 0 KB 0 KB 0 KB
SnapshotData 0 0 KB 0 KB 0 KB 0 KB
ChunkData 0 0 KB 0 KB 0 KB 0 KB
Notifications 0 0 KB 0 KB 0 KB 0 KB
Batch 0 0 KB 0 KB 0 KB 0 KB
Schedule 0 0 KB 0 KB 0 KB 0 KB
ReportSchedule 0 0 KB 0 KB 0 KB 0 KB
RunningJobs 0 0 KB 0 KB 0 KB 0 KB
ServerParametersInstance 0 0 KB 0 KB 0 KB 0 KB
Keys 2 32 KB 24 KB 8 KB 0 KB
History 0 0 KB 0 KB 0 KB 0 KB
(27 行受影响)
*/