Информация по базам от Ромы

Информация по базам

set nocount on
declare @res varchar(max)
declare @st table ([Database Name] varchar(100), [Log Size (MB)] real, [Log Space Used (%)] real, [Status] real)
insert into @st ([Database Name], [Log Size (MB)], [Log Space Used (%)], [Status])
exec('DBCC SQLPERF(LOGSPACE)')
declare @l int 
select @l=max(len([Database Name])) from @st
set @res='[Database Name]'+Replicate(' ',@l-len('[Database Name]'))+' [Log Size (MB)] [Log Space Used (%)] [Status]'+char(13)
select @res=@res+[Database Name]+Replicate(' ',@l-len([Database Name]))+' '	+str([Log Size (MB)],15,2)+' '+str([Log Space Used (%)],18,1)+' '+str([Status],8)+char(13) from @st
select @res