Being DBA
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
‹
›
Home
View web version
No comments:
Post a Comment