August 2, 2010 at 10:57 pm
Comments posted to this topic are about the item Show database size info across an instance
August 3, 2010 at 4:29 am
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
August 3, 2010 at 8:03 am
not sure why you used dbo.sysfiles i/o sys.database_files.
August 3, 2010 at 3:34 pm
You can use this free tool
August 6, 2010 at 12:48 pm
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.
August 7, 2010 at 3:41 am
August 26, 2010 at 1:55 pm
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'.
August 26, 2010 at 4:41 pm
August 21, 2013 at 9:16 am
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
August 21, 2013 at 9:43 am
Figured it out!!
Don't have enterprise edition.
Thanks
August 21, 2013 at 9:45 am
August 21, 2013 at 9:47 am
What helps?
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy