IT_girl
17-10-2011, 10:52
Bạn nào sửa dùm mình câu lệnh này, cám ơn bạn nhiều nha.
select
name as 'Data and Log Filename'
, filename as 'Path to Data and Log file'
, case
when convert(varchar(1),growth=0) like '0' then 'No Autogrowth Enabled'
when (maxsize=-1 and status=2) then 'Growth by ' + convert(varchar(3),growth) + ' MB until disk full'
when (maxsize=-1 and status=1048578) then 'Growth by ' + convert(varchar(3),growth) + ' % until disk full'
when maxsize <> -1 and status=2 then 'Growth by ' + convert(varchar(3),growth/128.000) + ' MB until' + convert(varchar(10),maxsize/128.000) +' MB'
when maxsize <> -1 and status=1048578 then 'Growth by ' + convert(varchar(3),growth) + ' % until' + convert(varchar(10),maxsize/128.000) +' MB'
when maxsize <> -1 and status=66 then 'Growth by ' + convert(varchar(3),growth/128.000) + ' MB until' + convert(varchar(10),maxsize/128.000) +' MB'
when maxsize <> -1 and status=1048642 then 'Growth by ' + convert(varchar(3),growth) + ' % until' + convert(varchar(10),maxsize/128.000) +' MB'
end as Growth
from sysfiles
select
name as 'Data and Log Filename'
, filename as 'Path to Data and Log file'
, case
when convert(varchar(1),growth=0) like '0' then 'No Autogrowth Enabled'
when (maxsize=-1 and status=2) then 'Growth by ' + convert(varchar(3),growth) + ' MB until disk full'
when (maxsize=-1 and status=1048578) then 'Growth by ' + convert(varchar(3),growth) + ' % until disk full'
when maxsize <> -1 and status=2 then 'Growth by ' + convert(varchar(3),growth/128.000) + ' MB until' + convert(varchar(10),maxsize/128.000) +' MB'
when maxsize <> -1 and status=1048578 then 'Growth by ' + convert(varchar(3),growth) + ' % until' + convert(varchar(10),maxsize/128.000) +' MB'
when maxsize <> -1 and status=66 then 'Growth by ' + convert(varchar(3),growth/128.000) + ' MB until' + convert(varchar(10),maxsize/128.000) +' MB'
when maxsize <> -1 and status=1048642 then 'Growth by ' + convert(varchar(3),growth) + ' % until' + convert(varchar(10),maxsize/128.000) +' MB'
end as Growth
from sysfiles