Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sylvia Moestl... » Easily calculate the size of your tables
Add to briefcase

Easily calculate the size of your tables Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Sylvia Moestl Vasilik
Posted Thursday, April 09, 2009 5:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, March 16, 2013 4:03 PM
Points: 14, Visits: 336
Comments posted to this topic are about the item Easily calculate the size of your tables
Post #693876
WILLIAM MITCHELL
Posted Monday, May 04, 2009 5:17 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:45 AM
Points: 1,441, Visits: 2,485
You could just use this
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?' "
Post #709313
rgupta-1037125
Posted Monday, May 04, 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
simon.murin
Posted Monday, May 04, 2009 8:58 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 7:36 PM
Points: 62, Visits: 474
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
Paul Abraham
Posted Tuesday, May 05, 2009 3:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 02, 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
Sylvia Moestl Vasilik
Posted Tuesday, May 05, 2009 9:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, March 16, 2013 4:03 PM
Points: 14, Visits: 336
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.