Show database size info across an instance
-
Comments posted to this topic are about the item Show database size info across an instance
Hope this helps,
Rich[p]
[/p] -
Just to note, OBJECT_SCHEMA_NAME was actually introduced in SQL Server 2005 SP2...
Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone -
not sure why you used dbo.sysfiles i/o sys.database_files.
-
You can use this free tool
-
Very 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.
-
Hi 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.
Rich
Hope this helps,
Rich[p]
[/p] -
Getting this error when I run on SQL Server 2008:
Msg 156, Level 15, State 1, Line 24
Incorrect syntax near the keyword 'END'.
Msg 102, Level 15, State 1, Line 37
Incorrect syntax near 'DECLARE
EXEC sp_MSforeachdb
@pages BIGINT -- Working variable for size calc.
,@dbname SYSNAME
,@dbsize BIGINT
,@logs'.
-
Hi,
It appears that there is a parenthesis ")" missing after DATA_COMPRESSION = PAGE
Rich
Hope this helps,
Rich[p]
[/p] -
Thank you Richard for the script. Newbie to SQL Server and am using 2008 R2 and am getting the following error:
Cannot enable compression for object 'DatabaseGrowth'. Only SQL Server Enterprise Edition supports compression.
Would apprecaite any help.
Thanks
-
Figured it out!!
Don't have enterprise edition.
Thanks
-
🙂
Hope this helps,
Rich[p]
[/p] -
What helps?
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply