MCITP

MCITP

Thursday, March 10, 2011

LOGSPACE FOR SINGLE TABLE

Create table #T1(db varchar(800),logsize decimal(18,5),logspace decimal(18,5),status int)
insert into #T1
exec ('dbcc sqlperf(logspace)')
select * from #T1 where db = 'BAAS'
drop table #T1

No comments:

Post a Comment