Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Easily calculate the size of your tables Expand / Collapse
Author
Message
Posted Thursday, April 9, 2009 5:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 4:24 PM
Points: 14, Visits: 364
Comments posted to this topic are about the item Easily calculate the size of your tables
Post #693876
Posted Monday, May 4, 2009 5:17 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 5:23 AM
Points: 1,522, Visits: 2,731
You could just use this
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?' "

Post #709313
Posted Monday, May 4, 2009 8:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 16, 2009 8:30 PM
Points: 1, Visits: 6
I am getting eror( i m using sql server 2005):

Msg 102, Level 15, State 1, Line 9
Incorrect syntax near ' '.
Post #709869
Posted Monday, May 4, 2009 8:58 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 11, 2014 7:38 PM
Points: 77, Visits: 572
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'
Post #709873
Posted Tuesday, May 5, 2009 3:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 2, 2011 9:02 AM
Points: 49, Visits: 191
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.
Post #710011
Posted Tuesday, May 5, 2009 9:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 4:24 PM
Points: 14, Visits: 364
Thanks for the comments. Some non-printing characters got in there - it should be fixed soon.
Post #710398
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse