Comments posted to this topic are about the item Show database size info across an instance
Just to note, OBJECT_SCHEMA_NAME was actually introduced in SQL Server 2005 SP2...
Atlantis Interactive - SQL Server Tools
Why I wrote a sql query analyzer clone
Hall of Fame
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.
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
@pages BIGINT -- Working variable for size calc.
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.
Figured it out!!
Don't have enterprise edition.
Viewing 12 posts - 1 through 11 (of 11 total)