CREATE TABLE #GrowthTable
(
Type_Desc varchar(50),
Name varchar(500),
Physical_Name varchar (max),
State_Desc varchar(50),
Size varchar(500),
Max_Size varchar(500),
Growth varchar(50),
Is_Percent_Growth varchar(50)
);
exec sp_msforeachdb “use [?]; insert into #GrowthTable select Type_Desc, Name, Physical_Name, State_Desc, Size, Max_Size, Growth, Is_Percent_Growth from sys.database_files”
select * from #GrowthTable
drop table #GrowthTable
Like this:
Like Loading...
Related
About Pratik Vyas
Hi Readers,
Welcome to Pratik’s SharePoint Blog.
First of all Thank you very much for taking interest and spending time to tour my Blog
I am in the ocean of SharePoint since January 2008 (almost 4 years), and still I feel I have to go more deep. I am working with a well known MNC as a SharePoint Consultant. Here I used consultant because I do a little development and customization with administration. I am very much interested in Microsoft products.
I have started blogging since 2008 but I can say in real manner I have started it in 2011 (as I have posted only 4-5 blogs from 2008 to 2011 J)
I believe there isn’t anything impossible in SharePoint, the only thing is sometimes we have to think something off track. I have posted couple of blogs which was discovered by going some off track, we can simply say it TRICKS.
Feel free to reach me in case of any issues or queries I will be more than happy to help you.
Good bye and Happy Reading, Cheers !!