SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Richard Douglas / Show database size info across an instance / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:39:05 GMT20RE: Show database size info across an instancehttp://www.sqlservercentral.com/Forums/Topic962585-2756-1.aspxHi, It appears that there is a parenthesis ")" missing after DATA_COMPRESSION = PAGERichThu, 26 Aug 2010 16:41:00 GMTRichardDouglasRE: Show database size info across an instancehttp://www.sqlservercentral.com/Forums/Topic962585-2756-1.aspxGetting this error when I run on SQL Server 2008:Msg 156, Level 15, State 1, Line 24Incorrect syntax near the keyword 'END'.Msg 102, Level 15, State 1, Line 37Incorrect syntax near 'DECLAREEXEC sp_MSforeachdb @pages BIGINT -- Working variable for size calc.,@dbname SYSNAME,@dbsize BIGINT,@logs'.Thu, 26 Aug 2010 13:55:42 GMTmsvobodaRE: Show database size info across an instancehttp://www.sqlservercentral.com/Forums/Topic962585-2756-1.aspxHi all, Thanks for your replies, I've not been able to respond before due to illness.Matt: That's really interesting, I'll bear that in mind, thanks.Pei Zhu: This is the way that MS chose to write the code inside sp_spaceused.DLRDBA: Glad this worked for you.RichSat, 07 Aug 2010 03:41:14 GMTRichardDouglasRE: Show database size info across an instancehttp://www.sqlservercentral.com/Forums/Topic962585-2756-1.aspxVery useful script. I have been doing some sp_spaceused manually to collect this data until I could write this, thanks for sharing a workable solution. I did run this on 2008 and 2005 version 9.00.4035.00 without any modification. Thanks again.Fri, 06 Aug 2010 12:48:18 GMTDLRDBARE: Show database size info across an instancehttp://www.sqlservercentral.com/Forums/Topic962585-2756-1.aspxYou can use this free toolhttp://www.sqldbtools.com/Tools.aspx?ProductId=3Tue, 03 Aug 2010 15:34:01 GMTbouarroudj MohamedRE: Show database size info across an instancehttp://www.sqlservercentral.com/Forums/Topic962585-2756-1.aspxnot sure why you used dbo.sysfiles i/o sys.database_files.Tue, 03 Aug 2010 08:03:25 GMTPei Zhu-415513RE: Show database size info across an instancehttp://www.sqlservercentral.com/Forums/Topic962585-2756-1.aspxJust to note, OBJECT_SCHEMA_NAME was actually introduced in SQL Server 2005 SP2...Tue, 03 Aug 2010 04:29:54 GMTMatt WhitfieldShow database size info across an instancehttp://www.sqlservercentral.com/Forums/Topic962585-2756-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL/70792/">Show database size info across an instance</A>[/B]Mon, 02 Aug 2010 22:57:44 GMTRichardDouglas