April 9, 2009 at 5:35 am
Comments posted to this topic are about the item Easily calculate the size of your tables
May 4, 2009 at 5:17 am
You could just use this
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?' "
May 4, 2009 at 8:48 pm
I am getting eror( i m using sql server 2005):
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '?'.
May 4, 2009 at 8:58 pm
It doesn't work -
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '?'.
on spt_values.number = 1 and spt_values.type = 'E'
May 5, 2009 at 3:51 am
Remove everything that looks like a space at the beginning of lines 10 and 11, i.e.
...
on spt_values.number = 1
and spt_values.type = 'E'
...
Paul.
May 5, 2009 at 9:45 am
Thanks for the comments. Some non-printing characters got in there - it should be fixed soon.
Viewing 6 posts - 1 through 6 (of 6 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