Easily calculate the size of your tables

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 1

You could just use this

EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?' "

rgupta-1037125 Grasshopper Points: 15 More actions · Answer 2

I am getting eror( i m using sql server 2005):

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near '?'.

simon.murin SSC-Addicted Points: 449 More actions · Answer 3

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'

Paul Abraham Valued Member Points: 67 More actions · Answer 4

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.

Sylvia Moestl Vasilik Old Hand Points: 384 More actions · Answer 5

Thanks for the comments. Some non-printing characters got in there - it should be fixed soon.