Situatie
Pentru situatiile in care avem nevoie sa vedem rapid cateva date despre o anumita baza am facut o procedura in sql ce primeste ca parametru numele unei baze si, pentru acea baza, returneaza urmatoarele informatii: numele fisierelor bazei de date, calea fizica a fisierelor bazei de date, statusul bazei de date, factorul de crestere, tipul de crestere (fix sau procent) precum si limita de crestere.
Solutie
create procedure BD_DatabaseSettings_prc @name varchar(max)
as
select smf.type_desc, smf.name, smf.physical_name as location, smf.state_desc as status , (8.0*(smf.size))/1024/1024 TotalGB,
case when smf.max_size = -1 then ‘UNLIMITED’ else convert(varchar(max),smf.max_size) end as MaxSize,
smf.growth as Growth,
case when is_percent_growth = 1 then ‘Percent’ else ‘Megabytes’ end as TypeOfGrowth
from sys.sysdatabases ssd
join sys.master_files smf on ssd.dbid = smf.database_id
where ssd.name = @name
Leave A Comment?