Monday, May 13, 2013

Query to Identify Database Settings for SharePoint in SQL Server


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

No comments:

Popular Posts

Disclaimer

The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.